help on reports sccm2012

[akrib]

hello

I want to give you my appologize for my horrible english ( i'm french)

 

I need help for a report on sccm2012

 

i want to create a report for view the state of application deployement for one user (success, error,requierement not met, unknown)

could you help me please ?

[akrib]

Hello again

i made this report

SELECT 

  vAppDeploymentAssetDetails.MachineName

  ,vAppDeploymentAssetDetails.UserName

  ,vAppDeploymentAssetDetails.CollectionName

  ,vAppDeploymentAssetDetails.StatusType

From

vAppDeploymentAssetDetails

where 

   vAppDeploymentAssetDetails.MachineName LIKE @variable

in the query designer it works but on sccm 2012 i have an error

Could you help me ?

Microsoft.Reporting.WinForms.ReportServerException

Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted)





Stack Trace:

   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)



-------------------------------



Microsoft.Reporting.WinForms.ReportServerException

Échec de l'exécution de la requête pour le dataset 'DataSet1'. (rsErrorExecutingCommand)





Stack Trace:

   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)



-------------------------------



Microsoft.Reporting.WinForms.ReportServerException

Pour obtenir plus d'informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.





Stack Trace:

   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)

   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)

   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()

   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()

   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)



-------------------------------

[GarthMJ]

Does this report work in the Web SSRS interface?

 

Also see this blog post to enable remote error reporting.

http://be.enhansoft.com/post/2013/01/16/Enabling-Remote-Errors-in-SQL.aspx

[akrib]

yes in the query designer it works

and thanks for your help

[GarthMJ]

I asked about the web interface not query designer. Did you also enable the remote errors, as per the blog?

[akrib]

i made a new report : it works and i hope it will help you

select Distinct 
DSC.CollectionName,
DSC.SoftwareName,
 fc.Name, 
CASE
WHEN (dbo.fn_GetAppState(ad.ComplianceState, ad.EnforcementState, cia.OfferTypeID, 1, ad.DesiredState, ad.IsApplicable) / 1000 = '1') THEN 'success'
WHEN (dbo.fn_GetAppState(ad.ComplianceState, ad.EnforcementState, cia.OfferTypeID, 1, ad.DesiredState, ad.IsApplicable) / 1000 = '2') THEN 'in progress'
WHEN (dbo.fn_GetAppState(ad.ComplianceState, ad.EnforcementState, cia.OfferTypeID, 1, ad.DesiredState, ad.IsApplicable) / 1000 = '3') THEN 'requierement not met'
WHEN (dbo.fn_GetAppState(ad.ComplianceState, ad.EnforcementState, cia.OfferTypeID, 1, ad.DesiredState, ad.IsApplicable) / 1000 = '4') THEN 'inactif' 
WHEN (dbo.fn_GetAppState(ad.ComplianceState, ad.EnforcementState, cia.OfferTypeID, 1, ad.DesiredState, ad.IsApplicable) / 1000 = '5') THEN 'error' 
ELSE 'error sql' 
END 'status',
datediff(day,WS.LastActiveTime,getdate()) as date 
FROM fn_rbac_DeploymentSummary(dbo.fn_LShortNameToLCID(@locale), @UserSIDs) DSC 
RIGHT OUTER JOIN fn_rbac_FullCollectionMembership(@UserSIDs) as fc on fc.CollectionID = DSC.CollectionID AND DSC.FeatureType = 1 
LEFT JOIN fn_rbac_AppIntentAssetData(@UserSIDs) ad ON ad.MachineID = fc.ResourceID AND ad.AssignmentID = DSC.AssignmentID 
INNER JOIN fn_rbac_CIAssignment(@UserSIDs) cia ON cia.AssignmentID = DSC.AssignmentID 
LEFT OUTER JOIN v_CombinedDeviceResources WS ON fc.ResourceID = WS.MachineID 
where fc.ResourceType = 5 AND fc.Name = @poste

[GarthMJ]

Stupid question is there an reason why you have combined both RBA and non-RBA data together?

[akrib]

sorry but i can't answer to you

i made this report by trying lot of sql table

i don't have any experience in SCCM or SRSS and i don't know RBA

 

but i really want to learn if you have any book or tutorial i will be gratefull

[GarthMJ]

There is a bit of a tutorial in the CM12 docs but it is really basic..