Lists Software Title, Computer Name, User, and Domain for all machines with Microsoft Office Installed.

Attachment

0 Comments   [ + ] Show 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.

Answers

0
Thanks for the report! Looks good.
Answered 02/10/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
I noticed one thing when I was looking in the "SQL Select Statement:" section. You have this listed "and DISPLAY_NAME like 'Microsoft Office%'". I do not know much about SQL but I think there should be a "%" before "Microsoft". I could be wrong, but when I changed it, the report created an additional 4 pages for me. The only reason I noticed it was because I am trying to learn how to use SQL and I was going to try and edit the report to create a different output. Sorry if I am incorrect!
Answered 02/10/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
I think there should be a "%" before "Microsoft".
I assume that in the end you have this:? DISPLAY_NAME like '%Microsoft Office%'

That means any software with the string "Microsoft Office" somewhere in the display name


DISPLAY_NAME like '%Microsoft Office%'
This means any software with the string "Microsoft Office" at the beginning of the display name

case comparisons are not made for pattern matching in our database.
Answered 02/20/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
You meant to say:
DISPLAY_NAME like 'Microsoft Office%'This means any software with the string "Microsoft Office" at the beginning of the display name
Answered 02/21/2010 by: RichB
Third Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity