Thursday, September 21, 2017

SQL Query for get User names to machines

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',
)

No comments:

Post a Comment

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...