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

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

yes in the query designer it works and thanks for your help

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) -------------------------------

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 ?