Does SCCM Store Historical information about deployments of Task Sequences and Applications so that this can be reported on at a later
- Proposed as answer by Daniel JiSunMicrosoft contingent staff, Moderator 5 hours 35 minutes ago
You can look at the status messages. It has entries for when a task sequence starts, the steps that are run, and when the task sequence ends.
- Proposed as answer by Daniel JiSunMicrosoft contingent staff, Moderator Thursday, March 26, 2015 2:07 AM
So once a deployment is deleted, then all historical data for that is gone? Poor design IMHO.
You can always submit a feedback item to connect.microsoft.com about this.
SSRS? SQL Server Reporting Services?
Can you point me to some resources such as SQL scripts or documentation that can help us set this up? or even which tables you are pulling data
Are you using a custom report or the built-in reports?
If built-in could you tell me which one(s)?
All our reports I wrote myself.
You could ship the data off in many ways, SSIS, pulling it out manually, etc. The MDT database may be an option, but if you use SQL Express your space and functionality may be limited. Our's is Express, so I would probably get a seperate DB if we went that route.
In ConfigMgr you generally want to use the views, they are customized in a presentable and consumable fashion...most of the time.
Here are a few reports of ours that I wrote. They are OSD focused, but should get you started.
OSD Task Sequence Summary Chart
Note the parameter @Timeframe, which is based on hours. 24 = 1 day, 48 = 2 days, etc
select case when LastState=0 then LastAcceptanceStateName when LastState=-1 then LastAcceptanceStateName else LastStateName end as Status, COUNT(*) as Count, Advert.AdvertisementID, Advert.PackageName from v_ClientAdvertisementStatus inner join dbo.v_AdvertisementInfo Advert on v_ClientAdvertisementStatus.AdvertisementID = Advert.AdvertisementID where DATEDIFF(hh,LastStatusTime, GetDate()) < @Timeframe group by case when LastState=0 then LastAcceptanceStateName when LastState=-1 then LastAcceptanceStateName else LastStateName end, Advert.AdvertisementID, Advert.PackageName
OSD Trending by timeframe
Same parameter as above.
select CONVERT(char(10),laststatustime,126) as [Date], case when LastState=0 then LastAcceptanceStateName when LastState=-1 then LastAcceptanceStateName else LastStateName end as [Status], COUNT(*) as Count from v_ClientAdvertisementStatus inner join dbo.v_AdvertisementInfo Advert on v_ClientAdvertisementStatus.AdvertisementID = Advert.AdvertisementID where DATEDIFF(DD,LastStatusTime, GetDate()) < @Timeframe group by CONVERT(char(10),laststatustime,126), case when LastState=0 then LastAcceptanceStateName when LastState=-1 then LastAcceptanceStateName else LastStateName end Order by CONVERT(char(10),laststatustime,126) desc