/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Need to get custom inventory item to show up in report

03/22/2016 1445 views
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:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1
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

All 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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ