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 = 8 Then ‘Application’

when v_Package.PackageType = 257 Then ‘Image Package’

when v_Package.PackageType = 258 Then ‘Boot Image Package’

when v_Package.PackageType = 259 Then ‘Operating System Install Package’

Else

‘Unknown’

End

from v_Package

 

Advertisements


Categories: Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: