Hunt SCCM Issues Down

Please find the query below. Change the application Name & Publisher Name according to your need. SELECT c.Name0, a.DisplayName0, a.Version0, c.AD_Site_Name0, b.LastUsedTime0 FROM v_GS_ADD_REMOVE_PROGRAMS a Join v_R_System c On a.ResourceID = c.ResourceID Join v_GS_CCM_RECENTLY_USED_APPS B On B.ResourceID = a.ResourceID WHERE a.ResourceID = c.ResourceID AND a.DisplayName0 like '% Adobe % Reader %' AND a.Publisher0 like '% Adobe %' AND Version0 like '11' GROUP BY c.Name0, a.DisplayName0, a.Version0, c.AD_Site_Name0, b.LastUsedTime0 ORDER BY c.name0

Please find the query below. select v_r_system.Client0 as 'SCCM Client',v_r_system.name0 as 'Machine Name',v_r_system.obsolete0 as 'Obsolete',v_r_system.Active0 as 'Active',v_R_System.AD_Site_Name0 as 'AD Site Location', v_r_system.user_name0 as 'User Name',v_ClientAdvertisementStatus.laststatename as 'Last State Name',v_advertisement.advertisementname as 'Advertisement Name', v_ClientAdvertisementStatus.laststatustime as 'Last Status Time',v_advertisement.ProgramName as 'Program Name',v_advertisement.PackageID as 'Package ID',v_advertisement.AdvertisementID as 'Advert ID', v_ClientAdvertisementStatus.LastExecutionResult from v_ClientAdvertisementStatus inner join v_advertisement on v_ClientAdvertisementStatus.advertisementid=v_advertisement.advertisementid inner join v_r_system on v_ClientAdvertisementStatus.resourceid=v_r_system.resourceid where v_advertisement.advertisementi

Please find the query below. select vrs.name0, a.Assignment_UniqueID as DeploymentID, a.AssignmentName as DeploymentName, sn.StateName as LastEnforcementState, assc.StateTime , a.CollectionName, assc.Lasterrorcode from v_CIAssignment a join v_AssignmentState_Combined assc on a.AssignmentID=assc.AssignmentID join v_StateNames sn on assc.StateType = sn.TopicType and sn.StateID=isnull(assc.StateID,0) join v_R_System vrs on vrs.ResourceID=assc.ResourceID where a.AssignmentID=" Put the Assignment ID of the deployment "