rss
twitter
facebook

Home

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



SyntaxEditor Code Snippetvar 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

SCCM Disk space for all servers IN C:

SELECT DISTINCT VFCM.Name,VGL.DeviceID0, VGL.Description0, VGL.VolumeName0,
VGL.FreeSpace0 as [Free(MB)],
VGL.FreeSpace0/1024 as [Free(GB)],
VGL.Size0/1024 as [Total(GB)],
VGL.FreeSpace0*100/VGL.Size0 AS X
FROM[dbo].v_FullCollectionMembership VFCM
JOIN [dbo].v_GS_LOGICAL_DISK VGL on VFCM.ResourceID = VGL.ResourceID
JOIN[dbo].v_R_System VRS ON VFCM.ResourceID = VRS.ResourceID
WHERE
VGL.DriveType0 =3
AND VGL.DeviceID0 = 'C:'
ORDER BY VFCM.Name, VGL.DeviceID0
Read More

Chassis type values in SCCM

when 1 then 'Other'
 when 2 then 'Unknown'
 when 3 then 'Desktop'
 when 4 then 'Low Profile Desktop'
 when 5 then 'Pizza Box'
 when 6 then 'Mini Tower'
 when 7 then 'Tower'
 when 8 then 'Portable'
 when 9 then 'Laptop'
 when 10 then 'Notebook'
 when 11 then 'Hand Held'
 when 12 then 'Docking Station'
 when 13 then 'All in One'
 when 14 then 'Sub Notebook'
 when 15 then 'Space-Saving'
 when 16 then 'Lunch Box'
 when 17 then 'Main System Chassis'
 when 18 then 'Expansion Chassis'
 when 19 then 'SubChassis'
 when 20 then 'Bus Expansion Chassis'
 when 21 then 'Peripheral Chassis'
 when 22 then 'Storage Chassis'
 when 23 then 'Rack Mount Chassis'
 when 24 then 'Sealed-Case PC

Ref:http://blogs.technet.com/b/breben/archive/2009/07/21/chassis-type-values-in-sccm.aspx

Read More
 
Powered by Blogger