Application Statistics

I am trying to produce a report of application statistics along the lines of

Application Name Devices with application Devices with installation failure Users with application Users with installation failure

The data is in the application statistics area on the summary page for the application

but does anyone know how to get at this information please?

Simon

April 29th, 2015 4:31am

In SQL you can use fn_ListObjectContentExtraInfo. For more information see the SMSProv.log when you select an application in the console.
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 4:48am

Hi Simon,

take a look at the availbale reports under Monitoring -> Reporting -> Reports -> Software Distribution - Application Monitoring... There you can find similar data. There are also other Folders regarding Software Distribution, where you can find useful information. Does this help?

Regards,

Stoyan

April 29th, 2015 4:59am

Thanks for the response Peter. From SMSProv.log I can see

Select * From SMS_ObjectContentExtraInfo Where ObjectID = ............

but obviously it's not as easy as just using that! Would you mind explaining just a bit more about how to go about thus using fn_ListObjectContentExtraInfo please? Am happy to try and work this out myself where I can but I am not a SQL expert and would appreciate just a bit more of a nudge in the right direction if you can please. 

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 5:05am

Right below that line it should show a SQL query that uses that function. It will look like this:

select all SMS_ObjectContentExtraInfo.DateCreated,SMS_ObjectContentExtraInfo.Description,SMS_ObjectContentExtraInfo.FeatureType,SMS_ObjectContentExtraInfo.LastUpdateDate,SMS_ObjectContentExtraInfo.NumberErrors,SMS_ObjectContentExtraInfo.NumberInProgress,SMS_ObjectContentExtraInfo.NumberInstalled,SMS_ObjectContentExtraInfo.NumberUnknown,SMS_ObjectContentExtraInfo.ObjectID,SMS_ObjectContentExtraInfo.ObjectType,SMS_ObjectContentExtraInfo.ObjectTypeID,SMS_ObjectContentExtraInfo.PackageID,SMS_ObjectContentExtraInfo.SoftwareName,SMS_ObjectContentExtraInfo.SourceSite,SMS_ObjectContentExtraInfo.SourceSize,SMS_ObjectContentExtraInfo.SourceVersion,SMS_ObjectContentExtraInfo.Targeted from fn_ListObjectContentExtraInfo(1033) AS SMS_ObjectContentExtraInfo  where SMS_ObjectContentExtraInfo.ObjectID = N'ScopeId_A351EC12-B25C-4327-80EE-247F25E4CE55/Application_c7e8c6e5-8702-46a7-9261-f294e44aae80'

April 29th, 2015 5:11am

Ah got you, thanks. Is there anything special needed to run this query outside of CM12? I am connected to the DB vi SQL Server Management Studio but just copying that query from the log and pasting it in to a new query window fails to run successfully. The messages back is that EXECUTE permission was denied on the object ..., ..., so is it now just a case of getting the SQL admins to grant me that permission on the listed objects (which will be very difficult!)

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 5:21am

Thanks Stoyan. I might of missed it but I did look at some of those reports but never found one that gave me that information which I could then use as a starting point. The ones from a title perspective that looked promising I always ended up with empty reports.  
April 29th, 2015 5:24am

Yes, that query should work. If you need to build a report, you need to have permissions to query the database.
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 5:25am

It does run if I create a report and use it as the dataset query and then run the report from the CM12 console. It just won't run if I am querying the DB directly so looks like I need to sort some permissions out.

Thanks for your help so far it is much appreciated. Only issue I have now is that whilst the query runs in a report and returns data frustratingly the figures for the Number Errors, Number In Progress, Number Installed, Number Unknown does not change no matter what application you select. All the other fields change and display the correct information, software name, Package ID etc.

The information is there and displayed in the console but the numbers just don't change in the report.

April 29th, 2015 5:57am

Maybe a stupid question, but are you adjusting SMS_ObjectContentExtraInfo.ObjectID when you select a different application?
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 6:08am

No not a stupid question :-) but yes I am changing that. As I said it returns different info for the Software name, Package ID etc. its just those stats that never seem to change. If you get a chance to try does it work for you?
April 29th, 2015 6:14am

Hi,

I just tried the query above. Those states numbers did not change while I changed the objectID.

Please try to run WQL query when you connect to root\sms\site_"sitecode" to see if you can get different numbers of the states.

Best Regards,

Joyce

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 11:25pm

Hi Joyce, tried running as a WQL query and get exactly the same results. Whilst the SoftwareName and PackageID etc. all change values as different queries are run, the stats numbers always stay the same.
April 30th, 2015 3:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics