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 […]

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 […]

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 […]