I need to find the users who have logged on to our servers

Products

• Client Management Suite

Issue/Introduction

As an Altiris administrator, I need to find the users who have logged on to our servers.

Environment

Release: 8.7

Resolution

NOTE: Please note that Broadcom Support does not support custom scripting or reporting so modifications to the script and report must be made by the user. Please contact Symantec Consulting Services for assistance with creating custom inventory scripts or custom reports, they can be reached here:

Symantec Professional Services

 

select c.Name, w.Domain, w.[User Name], w.[Last Login] , w.[Size(Bytes)]/1048576 as [Size (MB)]
from Inv_UG_User_Account_Windows w
join vcomputer c
on c.Guid = w._ResourceGuid
where [User Name] not like 'NT %'
and [User Name] not like 'IIS app%'
order by 1