Sccm 2012 R2 Installed Software Report
If you’re looking for SCCM 2012 R2 default report. SCCM 2012; ConfigMgr SCCM List of Default Reports. Computers with specific software installed This. Gary Simmons – MCS. A dashboard for System Center 2012 R2 Configuration Manager using SQL 2012. In reports for software updates contain.
Have you ever been ask to provide an audit of a specific installed software? Our SCCM Software Inventory reports shows installed software on your devices using data. This product gives access to 2 distinct reports:. Installed Software – Overview: This reports shows a count of a specific software installed on devices. You can enter the desired software or scope it using a collection. (How many Adobe products on my Workstations computers?). Installed Software – Details: By clicking on a number on the Overview report, you are sent to the Details report which shows all machines names and related information.
(See the Screenshots tab to see example of it) Note: Many companies do not standardize their own naming products. We recommend the to enhance data quality of theses reports.
I have an audit comming up and I would like to create a custom dash board for the auditors. This way they could find the info that they are looking for direclty. One of the reports that we will be giving them is the Count of all instances of software registered with Add or Remove Programs. The problem with this report is that it prompts you to enter in the group that you would like to run it against.
This does not work for dashboards. I want to copy the report and change the sql query in order to give it the name of the group as opposed to prompting for it. I cannot figure out how to do this. I will copy the code bellow and the group I want to run it against is Collection ID SMS000ES. If someone could help and explain what they are doing, I hopefully will be able to grasp this and apply it to other reports that they will want.
Sccm 2012 R2 Installed Software Report
Thanks SELECT DisplayName0, Count(.) AS 'Count', Publisher0, Version0, @CollID as CollectionID FROM vAddRemovePrograms arp JOIN vFullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = @CollID GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0 Select all. From the SQL edit screen look to the right and you will see a Prompts button. Clicking it will show you the variable for CollID and side query used to look up those values. If you want to just hardcode in a particular collection you can delete that prompt and then here is the fixed SQL query: SELECT DisplayName0, Count(.) AS 'Count', Publisher0, Version0, @CollID as CollectionID FROM vAddRemovePrograms arp JOIN vFullCollectionMembership fcm on arp.ResourceID=fcm.Resourc eID WHERE fcm.CollectionID = SMS000ES GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0. OK, I made the adjustments as listed and we are now getting the following error. I did remove the Prompt as well and that part did work.
An error occurred when the report was run. The details are as follows: Invalid column name 'SMS000ES'.
Error Number: - Source: Microsoft OLE DB Provider for SQL Server Native Error: 207 I will copy the code bellow SELECT DisplayName0, Count(.) AS 'Count', Publisher0, Version0, FROM vAddRemovePrograms arp JOIN vFullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = SMS000ES GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0 Select all. Hi tdisalvo You must declare the @CollID as this is a linked report, remove the prompt as socrates suggested and then use the following in your SQL Query.
Cheers Declare @CollID char(8) Set @CollID = 'SMS000ES' SELECT DisplayName0, Count(.) AS 'Count', Publisher0, Version0, @CollID as CollectionID FROM vAddRemovePrograms arp JOIN vFullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID WHERE fcm.CollectionID = @CollID GROUP BY DisplayName0, Publisher0, Version0 ORDER BY Publisher0, Version0 Select all.