Hello fellow Spiceheads, I am trying to to customize a report in SCCM 2012. Normally I use the out of the box reports, but I've been asked to create a report that lists the software on all systems. Torrent Windows 2000 Italiano Inglese on this page. I think the report would work better if I could create a report where I could input the software I am looking for and the report would give me a list of the computer names with that software installed. Does anyone have a script or maybe could walk me through creating this report.

I have been trying to see if I could find some kind of SQL script for this, but being new to SQL, it hasn't been easy. Any help would be appreciated. If I could enter the values for the software that I'm looking for and have the report spit out the name of the software as the heading and underneath that, a list of the computer names that have that software installed, it would be awesome!! Example of a query that mloftis03 is talking about. Computer name / OS / last User logon /Timestamp You can also very detailed with it. I also wanted more than this.

This is using SCCM 2012 r2. I am a newbie to the reports. I want to create a report to show all the computer's program in add/remove programs for a. Do you want to get a list back of all of the software installed on a specific computer? If so, this query. NormalizedName] FROM v_GS_INSTALLED_SOFTWARE_CATEGORIZED as CAT join v_R_System as SCCM on CAT.ResourceID. You'll need to setup a variable for @SystemName0 in your report. LEGO Batman 3 Beyond Gotham The Squad DLC-BAT.

I wanted maker/model/memory/bios version/Company Asset tag/IP addy:) You can navigate to Monitoring/Queries. Create a new query then choose Edit Query and you can copy/paste this code to get an example of a query. Select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System. Guitar Tuner Pro Apk Download. LastLogonUserName, SMS_R_System.LastLogonTimestamp from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = 'Adobe Acrobat Reader DC' You can also visit Asset Intelligence located at Monitoring Overview Reporting Reports Asset Intelligence. Example of a query that mloftis03 is talking about. Computer name / OS / last User logon /Timestamp You can also very detailed with it. I also wanted more than this.