ITMS Administrator Group

 View Only

Report for Security Accounts in NS 

Dec 09, 2014 11:37 AM

Sometimes you may see that list of accounts created over time is getting long, and you may need to have ir reported, exported or printed.  

I was missing such report, so I have created this simple one:

Security_accounts.png

You can easily create your new SQL Report with user Name, Email and Last Login Time:

Here is the query to make it:

  SELECT TOP 1000 [_id]
        ,[DisplayName]
        ,[Email]
        ,[LastLoginTime]
    FROM [Symantec_CMDB].[dbo].[Inv_Account_Details]

 

That's all, good luck :-)

 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Dec 09, 2014 12:12 PM

Nice job! Thanks for sharing. It certainly helps as a quick reference on what accounts you should disable at a minimum.

Related Entries and Links

No Related Resource entered.