Jump to content


akrib

help on reports sccm2012

Recommended Posts

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 ?

Share this post


Link to post
Share on other sites


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)


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



Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...