/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
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:

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%'
Answered 10/12/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment