Video Screencast Help

Add Filter option to Installed Software report

Created: 30 Oct 2012 | 1 comment
jebba's picture

Hello All -

Banging my head on this, but I'm sure its fairly simple - need some help on the out of the box installed software report (All Reports->Discovery and Inventory->Inventory->Cross Platform->Software/applications->Software->Installed Software)

I need to be able to run this against different filters in order to get a software install count against specific departments in our enterprise.

Any help would be greatly appreciated

Comments 1 CommentJump to latest comment

Falquian's picture

Hi, jebba:

For including a filter into a report you must follow the next steps:

Select the report where you need to add the filter, and click "Edit" in the upper right corner of the right window (near the end of the report's name), or begin creating a new report.

When the Report Builder Wizard appears, go to the "Report Parameters" tab.

Click "Add" and then "New Parameter" to add a new parameter to the report.

Fill in the required information, taking into account that

  • "Type" must be filled with "Basic GUID Parameter"
  • In the "Value Provider" section, select "Filter Chooser Parameter Control"

Press the Ok button.

Once the parameter is created, select the "Data Source" tab, and in the subtabs inside it, select "Query Parameters".

Here, click "Add" and select the parameter you created previously. It is automatically added to the list of Query Parameters.

Now, you can use it safely into your query. Remember to use it between % signs. A sample query can be
SELECT * FROM CollectionMembership cm
INNER JOIN vItem i ON i.Guid = cm.ResourceGuid
WHERE cm.CollectionGUID = N'%filter%'

Take into account that filter is the name of the parameter where the guid of the selected filter is stored, and that it must be enclosed between % signs, and in this sample, also is enclosed between the single aprotrophe sign.

Hope this helps you.

Kind regards:


If this post is useful to you, remember to mark it as a solution ;)