Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'd like to be able to query the "status" of a Task Sequence in SCCM 2007. SCCM comes with some semi-sophisticated reporting, among which is one entitled History - Specific task sequence advertisements run on a specific computer. This report provides the most useful information that I know how to get. It's not perfect, but if I could at least get this much, I would be able to do what I want.

I'm attempting to do this with WMI/WQL from a remote client (my desktop), querying the site database server. We usually use Perl. For this particular application, I'd prefer to use Python, but I'd take anything I could get at the moment.

Sadly, the report uses the view v_TaskExecutionStatus, and views are not (to my knowledge) available via WMI/WQL. Upon inspection of the view (on the database server itself), I see that it references the table dbo.TaskExecutionStatus. I can access this table using the DBI ODBC driver for SQL Server. Doing so circumvents the normal permissions used to protect the data on the server, and would not allow the script to be run by other users (without adding them to privileged groups outside the ones we're already using for the purpose of security).

Is there a way to access these DB tables via WMI/WQL? I don't see any reference to them when I edit a query in the SCCM console. Simple (SELECT * FROM X) queries referring to TaskExecutionStatus (and the corresponding view) fail.

I cannot find any reference to the table/view in the SCCM 2007 SDK. My Internet queries have turned up little. Can anyone give me advice? Is there a way to find out what is available via WMI/WQL?

(I asked this on StackOverflow, too. It seemed appropriate here, too.)

share|improve this question
    
Welcome to Server Fault! Please don't cross-post. The Stack Exchange sites have a mechanism for migrating questions to other sites in the network if the first site deems it off topic there. –  squillman Oct 29 '13 at 13:48
    
I wouldn't say it's off-topic. It's more "both-topic" and I wanted to get input from either programmers or admins. I won't cross-post, again, though. –  mojo Oct 29 '13 at 14:23
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.