We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

How do I loop out al fields inside SELECT * FROM WorkerProcess [Answered]RSS

1 reply

Last post Oct 24, 2009 03:24 PM by ksingla

  • How do I loop out al fields inside SELECT * FROM WorkerProcess

    Oct 21, 2009 11:53 PM|superdog|LINK

    I want to know what are all the fields available inside WorkerProcess table

    reason is: I want to query the worker process id and worker process name.

    This is very important for me. Any way for me retrieve the data?


    Set oWebAdmin = GetObject("winmgmts:root\WebAdministration")
    Set oW3WPs = oWebAdmin.ExecQuery( "SELECT * FROM WorkerProcess" )

    For Each oW3WP In oW3WPs
         
         oW3WP.GetExecutingRequests arrReqs                   
                 
             For Each oRequest In arrReqs

                 WScript.Echo "--start--"
                 WScript.Echo "process id: " + oRequest.ProcessID
                 WScript.Echo "process name: " + oRequest.ProcessName

             Next
    Next


    worker process table

  • Re: How do I loop out al fields inside SELECT * FROM WorkerProcess

    Oct 24, 2009 03:24 PM|ksingla|LINK

    You can browse through WMI namespace using CIM studio. You can dowload it from here.

    Thanks,
    Kanwal