Jump to content


  • 0
akrib

help on reports sccm2012

Question

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

8 answers to this question

Recommended Posts

  • 0
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

  • 0

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

Join the conversation

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

Guest
Answer this question...

×   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...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.