With the release of SCCM Configmgr current branch 1802 ,there are some exciting features added from its previous version 1710. When there are new features released ,certainly there will be changes to the database hence sql views/tables created which will help us to create some nice SSRS reports for reporting.
So with this current branch version 1802 ,what's new in SQL for reporting ?
There are about1586 unique SQL views with lots of information that you can retrieve the data from SQL database help you to analyze the data.
Out of these SQL view,there are about 19 SQL views which are newly added from its previous configmgr version 1710 listed below. There could be some SQL views that are common in this new version and old versions but some new data fields added which are not listed here.
Some of newly added SQL views listed below ,you might have already seen in Configmgr Technical preview releases , however they are now into production release.
v_Default_Browser
v_GS_DEFAULT_BROWSER
v_GS_MDM_DEVDETAIL_EXT01
v_HS_DEFAULT_BROWSER
v_HS_MDM_DEVDETAIL_EXT01
v_LifecycleDetectedGroups
v_LifecycleDetectedProducts
v_LU_LifecycleProductGroups
v_LU_LifecycleProductHashes
vex_AI_LifecycleProductGroups
vex_AI_LifecycleProductHashes
vex_GS_DEFAULT_BROWSER
vex_GS_MDM_DEVDETAIL_EXT01
vSMS_Ao_ServerPrereqMonitoring
vSMS_AoSiteServerMonitoring
vSMS_ManagementInsightResultsList
vSMS_ManagementInsightRuleGroup
vSMS_PhasedDeployment
vSMS_ScriptsExecutionSummary
As usual ,you can download the SQL views documentation from ConfigMgr 2012 to Configmgr Current Branch 1802 from Technet here
Happy reporting !
2 Comments
Hi ,
I have made Software in "Available" Mode. So once device name is added to collection is it possible to get a view / report is Software is made Available in Software center ? If so , can you share the query please.
Regards,
Manoj Nagarajan.
manojn.cse@gmail.com
why do you want the report with this information ?if you made software available ,they will be available in software if the client is healthy and for this ,you dont need to run any report. Report is only to know if the application installed on the PC or not . you can view the status of the deployment using default reports .
Regards,
Eswar