search cancel

SQL script that shows Software Packages

book

Article ID: 163653

calendar_today

Updated On:

Products

IT Management Suite Software Management Solution

Issue/Introduction

SQL script that shows Software Packages

Environment

ITMS 7.5 and higher

Resolution

This query looks only at packages that in the All Package folder itself in Console under Manage > All Resources > Organizational Views > Default >  All Resources (it excludes the includes “Software Package” and “Patch Software Update …” resources):

select
      Name
      ,Description
from dbo.RM_ResourcePackage
where Attributes ='0'
      and Name not like '%BDC%'
      and Name not like '%DriversDB%'

This query looks at all packages under the All Packages folder in Console under Manage > All Resources > Organizational Views > Default >  All Resources (includes “Software Package” and “Patch Software Update …”):

select
      Name
      ,Description
from vRM_Package_Item
where Attributes ='0'
      and Name not like '%BDC%'
      and Name not like '%DriversDB%'
      and Name not like '%RMS%'