Full usernames:-
---------------------------------------
select
sys.netbios_name0, usr.Full_User_Name0,
usr.Unique_User_name0,
usr.User_Name0
from v_r_user Usr
join v_r_system sys on sys.user_name0=usr.User_name0
where sys.resource_domain_or_workgr0 = 'NA'
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 Query for Computers Disk Space :- Select v_R_System.name0, v_R_System.Resource_Domain_OR_Workgr0 as Domain, v_GS_LOGICAL_DISK....
-
SQL Query To Return Add OR Remove Programs Installed On A Specified Machine SQL Query: Select P.DisplayName0, P.ProdId0, P.Publis...
No comments:
Post a Comment