IT Management Suite

 View Only

 Extracting info from Unix targets for every username login on a machine

Jump to Best Answer
Hagai Nachmani's profile image
Hagai Nachmani posted May 30, 2021 08:39 AM
Hi Experts,
I wish to find a query (or even better: SMP internal build-in report) that will show me all usernames that are able to login to a end target.
I wish to use such query/report, and to view it on a list of my entire Unix systems

Did someone already encounter such a query before?  If so, are you willing to share please?


tnx,

Hagai
Chris Farrell's profile image
Broadcom Employee Chris Farrell Best Answer
Hi Hagai - try this:

select
vc.name,
vc.Domain,
vc.[IP Address],
vc.[OS Name],
au.[User Name],
au.[Full Name],
au.[Home Directory]
from vUGUserAccountUNIX au
join vcomputer vc on vc.guid = au._ResourceGuid
order by vc.name, au.[User Name]