Licencemanagement with SMS2K3 and SQL. SQL Query to long. Other Wa

I use the v_Add_Remove_Programs-Table to check what Software our employs use.
I created some Reports for every kind of it. Licenced, Not Licenced,
Freeware etc...
Now i want to see when a User installs an non-checked Software. So i wanted
to summerize all Querys/Reports which i created and check it against the
v_Add_Remove_Programs-Table. Long story short: i couldnt find a way to tell
SQL/SMS that it should summerize the Querys. Then i thought i could fit all
manually into one new Query. But there is a max letters limit in it.

What can i do? Or is there an easyer way to categorize Software?
.

Loading