SQL joing
I am trying to use Kace to create a report to see what PCs in my company have Microsoft Map Point on them and I am not sure how to do a join on the 2 SQL databases. Can anyone help me here. I know that software and hardware are on 2 different DBs, i just do not know how to join those 2 DBs in code so I can generate a report that tells me which of the PCs in my company have Map POint and if I can tell the last time it was used. I am new to Kace so I hope I am asking this correctly. let me know if you need any more info. Thank you.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
GillySpy
12 years ago
Software is stored in SOFTWARE and machines are stored in MACHINE -- both in the same database (ORG1 for most customers, ORGX for some)
Since a piece of software can be on many machines and a machine can have many pieces of software you will join them through MACHINE_SOFTWARE_JT
The easiest thing to do is create a report and dissect the SQL. Or view some of the example reports in the kb, appdeploy or canned in the kbox
One for this question:
Since a piece of software can be on many machines and a machine can have many pieces of software you will join them through MACHINE_SOFTWARE_JT
The easiest thing to do is create a report and dissect the SQL. Or view some of the example reports in the kb, appdeploy or canned in the kbox
One for this question:
select M.NAME PC FROM MACHINE M JOIN MACHINE_SOFTWARE_JT MS ON MS.MACHINE_ID=M.ID JOIN SOFTWARE S ON S.ID=MS.SOFTWARE_ID
WHERE S.DISPLAY_NAME LIKE '%map point%'
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
