These tables should get your that type of info.
[ProductComputer] AS PC
Product AS P ON P.Product_Idn = PC.Product_Idn
Computer AS C ON PC.Computer_Idn = C.Computer_Idn
This is exactly what I was looking for, thank you.
I have another SQL related question.
I have tagged our software packages to be tagged with a value in reg at HKLM\Software\Company\Packages\*Applications*
I have found the tables for the tagged applications in SQL under dbo.CustomData_Reg, what I cant find is a key to link the app to a computer (no computer.idn?)
Could you help me with how or where it could be linked?
1 of 1 people found this helpful
No worries. That is a very good question because there's no values in that table it just seems to be the list of custom data. I cannot seem to find a link. I thought it was unmodeleddata but doesn't fit the data. I don't have enough time to have a good look today though unfortunately.
Just wanted to say Thank you again for your help. I was able to locate the information I was looking for.
New issue is that I need to provide software Installed date in one of my report. I have found the detected date for all software which is the date LD was installed on and when it ran inventory scan. Any ideas where I could look to find the actual installed date for each application?
No worries. Where did you find the custom data stuff out of curiosity?
Install date is available under software > add \ remove programs in inventory. The table is AppSoftwareSuites. I believe it pulls this date from the client registry in the uninstall keys so shouldn't matter when LD agent was installed.
Under dbo.Product > Product_Idn