Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query for currently logged on users
- Thread starter raptoid
- Start date
Right-click on "Queries -> New -> Query"
Give it a name, and click on "Edit Query Statement"
Click on "Show Query Language" and paste the query below into the statement box
SELECT Name, LastLogonUserName, SMSAssignedSites, Client, IPAddresses, IPSubnets, IPXAddresses, IPXNetworkNumbers, MACAddresses, OperatingSystemNameandVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, AgentName, AgentSite, AgentTime, SNMPCommunityName, SystemRoles, SMSUniqueIdentifier, ResourceId, ResourceNames, ResourceType, NetbiosName from sms_r_system where LastLogonUserName = ##PRM:sms_r_system.LastLogonUserName##
To run, right click on the query, go to execute, and enter the users name into the text box. There you go!
Two caveats: 1) it needs to be the exact logon name. Entering %partialname% doesn't work for some reason. 2) This is only as accurate as the last software (or hardware?) inventory. If you want up to the minute stats, you're better off digging through the WINS database for names, and going from there.
hope this helps!
- alex
Give it a name, and click on "Edit Query Statement"
Click on "Show Query Language" and paste the query below into the statement box
SELECT Name, LastLogonUserName, SMSAssignedSites, Client, IPAddresses, IPSubnets, IPXAddresses, IPXNetworkNumbers, MACAddresses, OperatingSystemNameandVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, AgentName, AgentSite, AgentTime, SNMPCommunityName, SystemRoles, SMSUniqueIdentifier, ResourceId, ResourceNames, ResourceType, NetbiosName from sms_r_system where LastLogonUserName = ##PRM:sms_r_system.LastLogonUserName##
To run, right click on the query, go to execute, and enter the users name into the text box. There you go!
Two caveats: 1) it needs to be the exact logon name. Entering %partialname% doesn't work for some reason. 2) This is only as accurate as the last software (or hardware?) inventory. If you want up to the minute stats, you're better off digging through the WINS database for names, and going from there.
hope this helps!
- alex
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question