How to make UPDATE SELECT

UPDATE [TableName]
SET [Field]= BB.[Field]
                  FROM [TableName] BB
                                        INNER JOIN [TableName] AA ON BB.[Field] = AA.Field
Read More

Javascript LOGON_USER

var WinNetwork = new ActiveXObject('WScript.Network');
document.getElementById('"+Logon.Id+"').value = WinNetwork.UserName;

Read More

SCCM Programs used by users in the last 7 days

SELECT DISTINCT DATEDIFF(DAY, rua.lastusedtime0, GETDATE())AS[Days Since Last Used]
,sysvalid.netbios_name0 AS [Computer Name]
,rua.productname0 AS APPLICATION
,rua.filedescription0 AS [File Description]
,rua.explorerfilename0 AS [File Name]
,rua.fileversion0 AS [File Version]
,rua.companyname0 AS publisher
,CASE WHEN ( ISNULL(rua.productcode0, N'') = N'') THEN 'N'ELSE 'Y'END AS [Associated with an Installer]
,rua.lastusedtime0 AS [Time Last Used(GMT)]
,rua.lastusername0 AS [Last Used By]
,rua.TimeStamp
FROM [dbo].v_gs_ccm_recently_used_apps AS rua
                              LEFT JOIN[dbo].v_r_system_valid AS sysvalid ON rua.resourceid = sysvalid.resourceid                       
WHERE lastusername0 Like '%@user%' AND rua.ExplorerFileName0 NOT LIKE '%.tmp' AND rua.fileversion0 NOT LIKE ''
AND  DATEDIFF(DAY, rua.lastusedtime0, GETDATE())<=7
Read More

SCCM DETAILS DISK

 /********** DETAILS DISK *****************/
 SELECT GD.InterfaceType0,GD.Name0,(GD.Size0),gd.Partitions0,GD.ResourceID
 FROM [dbo].[v_GS_DISK] GD
 WHERE GD.ResourceID=@ResourceID

  /********** DETAILS DISK *****************/
 SELECT Ld.Description0,ld.DeviceID0,Ld.FileSystem0,LD.FreeSpace0,LD.Size0,LD.VolumeName0
 FROM [dbo].[v_GS_LOGICAL_DISK] LD
 WHERE LD.ResourceID=@ResourceID
Read More

SCCM 2012 View installer programs by ResourceID

SELECT vARP.DisplayName0, vARP.Publisher0, vARP.Version0 ,vARP.InstallDate0,vARP.TimeStamp
FROM[dbo].v_Add_Remove_Programs vARP
JOIN  [dbo].v_R_System vRS ON vARP.ResourceID = vRS.ResourceID 
WHERE vRS.ResourceID = @ID
Read More