/build/static/layout/Breadcrumb_cap_w.png

Need to get custom inventory item to show up in report

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]

0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: brianfulcher15 8 years ago
Orange Belt
1

Top Answer

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]
Posted by: SMal.tmcc 8 years ago
Red Belt
0
you can use the wizard and create this report easier,  Just select the machine name and the cir for columns and run it

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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