Tuesday, July 25, 2017

Region wise available machines report

Region wise available machines report :-



select distinct

sys.netbios_name0, usr.Full_User_Name0,
usr.Unique_User_name0,
usr.User_Name0,
Usr.Mail0,
sys.USer_domain0
from v_r_user Usr
join v_r_system sys on sys.user_name0=usr.User_name0


where sys.resource_domain_or_workgr0 = 'AS'

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