SQL script that shows Software Packages

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%'