CripWalk

I would check the drivers package BRS0007C that was evaluated and installed. Is it pointing to drivers for HP Prodesk 400 G3 DM or HP ProDesk 400 G4 DM or any other model for that matter?.

Looking at the log file, it looks like the machine you are imaging is grabbing an IP address. I think you named the SCCM task/action wrong. The TS action "HP ProDesk 400 G4 DM" (which should be your drivers package for G4 DM) has a condition "SELECT * FROM Win32_ComputerSystem WHERE Model LIKE "%HP ProDesk 400 G3 DM%". I would make sure to correct the action name to match the machine name being evaluated by the query and confirm that the drivers included in the G3 DM package are correct.

GarthMJ, Thanks for your replies. I created a query first in CM and then used it to create the report using Report Builder. I will try your suggestions and give feedback. I am only trying to learn how to create reports just in case I need a custom one at work in the future. The only time that I created a report through SQL Management Studio is when I made the Computer and Hardware report. I guess I don't have a solid base on how and where to create them. I just search for tips online and go for it. What books do you suggest to learn more about reports? Thanks for your time.

Hi all. I have sucessfully created an SCCM report using Report Builder. It is a report of all computers with Winamp installed. It looks like this:- What I would like to do is add a collection parameter so that I can sort computers with Winamp installed by device collections. I tried to follow this link (https://prajwaldesai.com/how-to-add-collection-parameter-in-sccm-report/), but I encountered a SQL pop-up error when I add the two lines to the dataset properties. (Lines added) join v_FullCollectionMembership fcm on fcm.resourceid=SYS.resourceid where fcm.Collectionid= @Collection (SQL Pop-Up) Below is the SQL query that I used to get the report. select all SMS_R_System.Name0,__System_ADD_REMOVE_PROGRAMS0.DisplayName00,__System_ADD_REMOVE_PROGRAMS0.Publisher00,__System_ADD_REMOVE_PROGRAMS0.Version00 from vSMS_R_System AS SMS_R_System INNER JOIN Add_Remove_Programs_DATA AS __System_ADD_REMOVE_PROGRAMS0 ON __System_ADD_REMOVE_PROGRAMS0.MachineID = SMS_R_System.ItemKey INNER JOIN _RES_COLL_SMSDM003 AS SMS_CM_RES_COLL_SMSDM003 ON SMS_CM_RES_COLL_SMSDM003.MachineID = SMS_R_System.ItemKey where __System_ADD_REMOVE_PROGRAMS0.DisplayName00 = N'Winamp' I admit that I am a not proficient with SQL. Can somebody help in figuring out what is it that I am missing? I am using SCCM 1610 with SCCM SQL 2014. Any help is greatly appreciated. Thanks.

Great work Niall. I installed the upgrade last night successfully in my lab.