History

Does SCCM Store Historical information about deployments of Task Sequences and Applications so that this can be reported on at a later

March 25th, 2015 5:23pm

If I am not mistaken, as long as the deployment is not deleted, the deployment status information will be maintained.  If you delete the deployment however I don't believe you will have access to the information any more.
Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 5:30pm

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.

March 25th, 2015 5:32pm

If I am not mistaken, as long as the deployment is not deleted, the deployment status information will be maintained.  If you delete the deployment however I don't believe you will have access to the information any more.
Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 9:28pm

v_TaskExecutionStatus
March 26th, 2015 2:24am

So once a deployment is deleted, then all historical data for that is gone?  Poor design IMHO.
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2015 5:37pm

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.
March 26th, 2015 5:48pm

Yeah, that would require a data warehouse feature I would think which has never been built in.  Interesting idea though!
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2015 12:41am

We just setup trending and reports in SSRS and have a subscription that runs weekly. We can aggregate the data and keep all the history, so if the deployments are ever removed, we still have the history. 
March 28th, 2015 1:41pm

Interesting Daniel.  Are you storing the data in a separate database I assume?  Possible to share any scripts or info on how you are accomplishing this?  :-)
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2015 10:37am

We aren't right now, but we have the historical SSRS reports in email. If we needed to aggregate it, we would just need to pull it together.
April 1st, 2015 9:46am

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

Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 9:56am

Yes, the ConfigMgr Reporting Point leverages SSRS for reporting. We setup subscriptions and get a weekly email with the details of the report in HTML.
April 1st, 2015 10:07am

Gotcha, thanks Daniel.  So you are just using data in reports you save versus shipping data from SQL to another system.  I may take a look at shipping deployment status to a separate DB for historical reporting.  I suppose if you are using the MDT database this may already be an option?
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 10:39am

Are you using a custom report or the built-in reports?

If built-in could you tell me which one(s)?

April 1st, 2015 1:30pm

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.

Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 1:34pm

We use a full version of SQL 2008R2.  Our management is looking to gather information on all of our Application/Package/OSD/Task Sequence deployments.  I could ask one of the members of my team to write the reports, but I'm not certain which tables would contain this data.  Could you point me in the right direction in regards to tables or views?  Sorry I'm not knowledgeable about SQL.
April 1st, 2015 1:43pm

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
Free Windows Admin Tool Kit Click here and download it now
April 3rd, 2015 11:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics