Select Distinct
SiteCode,
Role,
'Status' = Case
When Status = 0 Then 'OK'
When Status = 1 Then 'Warning'
When Status = 2 Then 'Critical'
Else ' '
End
From v_SiteSystemSummarizer
All current Deployment Dashboard
This Dashboard will show all active deployments on your SMS - SCCM with all percentage of each one:
select adv.AdvertisementName, adv.Comme…Read More
Microsoft Communicator Clean CacheThis Script will clean Microsoft Communicator cache and solve minor issues:
Option Explicit 'On Error Resume Next'==== variables ==================…Read More
Last Boot up time reportThis Report will show the exact machine last boot up time, HW scan, last heartbeat:
SELECT
a.Netbios_name0,
e.Caption0 as OS,
e.C…Read More
0 commenti:
Post a Comment
Give me you feedback!