Products
Applications
Support
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
My Communities
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
All Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Members
IT Management Suite
View Only
Community Home
Threads
3.7K
Library
253
Members
390
Back to {0}
Extracting info from Unix targets for every username login on a machine
Jump to
Best Answer
Thread closed by the administrator, not accepting new replies.
Add a tag
x
User Tags may not contain the following characters: @ # $ & :
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
Broadcom Employee
Chris Farrell
posted Jun 01, 2021 10:46 AM
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]
Copyright 2019. All rights reserved.
Powered by Higher Logic