September 14, 2011 at 8:06 am
Hi all I have a bunch of Active Directory accounts that were set up in the past as service accounts, (Some for SQL) does anyone k:-Pnow of a tool that can be used to determine what applications or processes are using these accounts?
Thanks a ton.
September 14, 2011 at 9:24 am
That seems like a totally impossible (or at least inaccurate) task. How would you be able to locate processes or services that might be logging in using a given account? Especially if it is currently not running. This is kind of like asking what applications are using a certain database. You just have no idea until they actually do.
You could add some login auditing to your sql server and monitor what sql logins have activity. Other than auditing and being patient for things to connect I don't know of any other way to determine this.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 14, 2011 at 9:30 am
Sorry but I had to ask the question,in this day and age there are third party apps for everything...
September 14, 2011 at 9:39 am
There may be somebody else with knowledge of some tool that can do this but it seems pretty tough. It is kind of like asking "what data is missing from the master table?". 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 14, 2011 at 9:42 am
Thanks for the reply,maybe their is a Admin the specializes in domain audits..:-):-P
September 14, 2011 at 9:45 am
If you have systems center, or an equivalent, or want to do WMI scripting, you can probably initiate scans across your various Windows hosts to get a list of all service accounts in use. If you toss the local stuff, you might end up with a reasonable amount of data. Drop it into a table and then you can query for it.
I'll ask some AD folks if they have other ideas.
September 14, 2011 at 9:55 am
Thank you very much..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply