SCCM Applications Report

[l.hv.yang]

Hey Guys,

 

I've created two reports that I need to combine into 1 report.

 

One report queries for "local MS Project' installed and the other queries for "app-v MS project" installed. I'm having a tough time getting the two reports to play well together. Ideally i'd like for the report columns to look something like this:

 

Division/Department | PC Name | OS | MS Project Local | MS Project Virtual |

 

Again, i've got two separate reports, but the 'uppers' have requested combining the data into one report. Is it possible?

 

 

Any sql experts here? :-)

 

Thanks!

[l.hv.yang]

ack, figured it out! had to use the UNION sytnax to combine the two select statements.

 

Select a, b, c

from table1

 

Union

 

Select a, b, c

from table 1

 

It's a beautiful report!