I have a custom inventory rule that pulls in monitor serial numbers. I need to create a report of this information for all workstations.  

currenlty my code is 

[CODE] 

SELECT 
    MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE
FROM
    ORG1.MACHINE_CUSTOM_INVENTORY
WHERE
    MACHINE_CUSTOM_INVENTORY.ID = MACHINE.ID
        AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = 4469

 [/CODE]
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
I got figured out, here's what i ended up with.

[code]
SELECT MACHINE.NAME, MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE
FROM MACHINE
join MACHINE_CUSTOM_INVENTORY ON MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND (SOFTWARE_id=4469)
WHERE MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=4469
[/code]
Answered 03/22/2016 by: brianfulcher15
Orange Belt

Please log in to comment

Answers

0
you can use the wizard and create this report easier,  Just select the machine name and the cir for columns and run it
Answered 03/22/2016 by: SMal.tmcc
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity