select distinct Netbios_name0,USer_domain0,v.User_Name0,Mail0,v_R_User.Full_User_Name0
from v_r_System v
inner join v_R_User on v_r_user.User_Name0 = v.User_Name0
where v_R_User.Full_User_Name0 in (
'Sylvia Liga',
'Jason Paw',
)
Subscribe to:
Post Comments (Atom)
site backup job manually
Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...
-
Application app enforcement deployment status with installation errors select distinct vrs.user_name0,fn.machinename,fn.applicationnam...
-
SQL for Last_Logon_Timestamp0 and LastHWScan : select Distinct v_R_System.Netbios_Name0 as 'Device Name', v_R_User.Full_User_...
-
Select v_R_System.name0, v_R_System.Resource_Domain_OR_Workgr0 as Domain, v_GS_LOGICAL_DISK.FreeSpace0, v_GS_LOGICAL_DISK.Size0, v_GS_...
No comments:
Post a Comment