Monitoring packages referenced by OS task sequence(s)
I'm stumped on this one! If you can get a hold of someone on the product team at Microsoft, they may be able to answer your question. Wish I could be of more help!
November 7th, 2012 2:41pm

Hello SCCM gurus out there, we're running a quite large infrastructure with several task sequences each of them referencing one ore more packages. It can happen that a package for an old version of a software is deleted after the new version has been deployed but is still referenced by one or more task sequences. As we all know, this leds to a failure when running one of these task sequences because the referenced package that has been deleted can't be located anymore. To deal with this problem we want to implement a monitor that watches all referenced packages and creates an alert (SCOM) or sends a mail to our team when it detects a "missing package". I'm now trying to build a SQL query to get the needed information from database. In the table 'dbo.TS_References' the references for the task sequences are defined via the ProgramIDs. (Column TS_ID = ProgramID of TS package's program // Column TS_ReferenceID = ProgramID of referenced package's program) My problem is that this "reference record" gets deleted when the appropriate package is deleted. From where does SCCM get the information about referenced packages after they have been deleted? The information must be stored somewhere because in the admin console (TS editor) the referenced package is still displayed and an error message informs you that the package can not be found. Who has any idea that could help me in this case? Thanks in advance... pisus
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2012 9:43am

Check out v_TaskSequenceReferencesInfo... I think that shows you all the packages that a specific TS calls.
November 10th, 2012 10:56am

Hello Dan, No, the view v_TaskSequenceReferncesInfo is querying from the dbo.TS_References table mentioned in my original post. That's why it does not contain any reference information after the package has been deleted.
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2012 12:03pm

I'll start looking for some more information, but it's possible that the Task Sequence is stored in XML format and the deleted packages are still referenced in it because it's a flat file...
November 10th, 2012 12:52pm

Hi Dan, thank you so far. I think it would be no problem to parse a XML file if we can't get the information from the database. We only need to know where the information is stored... Greetings and regards. pisus
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2012 1:30pm

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

Other recent topics Other recent topics