like this?
select sys1.netbios_name0,
cuser.SystemConsoleUser0, cuser.LastConsoleUse0
from v_r_system sys1
left join v_GS_SYSTEM_CONSOLE_USER cuser on cuser.ResourceID=sys1.ResourceID
join v_FullCollectionMembership fcm on fcm.resourceid=sys1.ResourceID
where fcm.collectionid = 'Input a CollectionID here, like SMS00001'
On Monday, February 1, 2016 9:10 AM, Kevin Ray <[email protected]>
wrote:
Hi Team,
I'm looking for a specific collection membership machines with Primary users in
SQL query
Note :----Hardware 03A - Primary Computer User -- Is showing like Primary users
count then if we drill down its showing the machine names --
