ServiceNow-SCCM integration without SNOW orchestartion

Solution to bypass SNOW orchestration for Service Portal to be used as Frontend for application install Action from SNOW User browses to Appstore(Service Portal) instance with web browser. User locates application to install and “orders” it which generate new request in SNOW that defines the application is ordered with Application Name, Device Name and Collection … Continue reading ServiceNow-SCCM integration without SNOW orchestartion

Advertisements

ConfigMgr – SQL query to find Package type

select *, 'Package Type (Text)' = Case when v_Package.PackageType = 0 Then 'Software Distribution Package' when v_Package.PackageType = 3 Then 'Driver Package' when v_Package.PackageType = 4 Then 'Task Sequence Package' when v_Package.PackageType = 5 Then 'Software Update Package' when v_Package.PackageType = 6 Then 'Device Setting Package' when v_Package.PackageType = 7 Then 'Virtual Package' when v_Package.PackageType … Continue reading ConfigMgr – SQL query to find Package type

ConfigMgr – SCCM Advertisement, Package Type and Program Information with Target Count

select CollectionID, COUNT(*) as MemberCount into #TempTable from v_FullCollectionMembership group by CollectionID SELECT dbo.v_Advertisement.AdvertisementID, dbo.v_Advertisement.AdvertisementName, 'PackageType' = Case when v_Package.PackageType = 0 Then 'Software Distribution Package' when v_Package.PackageType = 3 Then 'Driver Package' when v_Package.PackageType = 4 Then 'Task Sequence Package' when v_Package.PackageType = 5 Then 'Software Update Package' when v_Package.PackageType = 6 Then 'Device … Continue reading ConfigMgr – SCCM Advertisement, Package Type and Program Information with Target Count