SQL Query To Retrieve All MOM Server User Accounts

 

This simple SQL query will return the MOM Server user names and the time stamp when the account(s) was created.

 

SQL Query:

 

Select  

Name 'User Name',

Convert(VarChar(30), TimeAdded, 109) 'Account Created'

From [User]

Where Name <> 'N/A'

Order By 'User Name'

 

Published Sunday, June 24, 2007 8:18 AM by dhite
Filed under:

Comments

No Comments