I have set up the correct SCCM software metering rules for each of the Office suite executables like Outlook.exe, MsWord.exe etc. I would like to report on usage of each executable in the Office suite. This is useful for us because we can work out things like if a user only uses Outlook and nothing else in the Office suite then we can move them to Outlook Web Access and uninstall Office, therefore reducing the number of Office licenses required.

I'm sure the data is there but not sure how to extract it. For all the machines in the environment, I would like to have a report showing something like this:

 

 

Name  Last date Outlook.exe used   Last date Excel.exe used

PC001  01/01/2011              15/03/2011

PC002  02/02/2011              Never run

PC002  Never run                Never run

 

 

There doesn't seem to be an existing report that I could use / modify, just wondering if anyone has attempted this before?

• Edited by danovich_ Friday, August 19, 2011 12:41 AM fixed code block

I wonder, what is the use of this report. I think, you can try to create a custom report with the help of two links given below?

http://myitforum.com/cs2/blogs/jmarcum/archive/2011/05/19/157675.aspx  (Beginners Guide to Writing SCCM Reports)

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22052 ()Creating Custom Reports By Using Configuration Manager 2007 SQL Views)

 

I know this is a bit old but Google led me here earlier.

 

Having needed a similar report, I found the information is in v_GS_CCM_RECENTLY_USED_APPS. You should be able to do left joins and whatnot in order to get the desired look you are going for.

 

If you need more info, let me know and, when I get mine done (working on it now actually), I can share it with you... or, if you have the answer, feel free to share.  :)

 

 

• Proposed as answer by Garth JonesMVP, Moderator Wednesday, October 12, 2011 11:40 AM
• Marked as answer by Garth JonesMVP, Moderator Thursday, November 01, 2012 12:24 AM

Keep in mind that the inventory data can be 7 days out of date (default setting). Also remember that enabling Recently Used Apps will cause problem on Citrix servers as it will provide too much data and CM07 might not be able to handle it.

 

But a good idea.

Hi Greg,

Did you ever have any luck with this report?  I've tried using the table you referenced, however I'm unable to get desired results.  Any help would be appreciated.

Thanks,

Chris

• Edited by Christopher M. Oliver Wednesday, April 23, 2014 9:00 PM