none
Is there any way to export queue jobs ?? RRS feed

  • Question

  • Hi,

    PS 2007 -

    We generally analyse queue jobs weekly. Queue shows thousands of jobs a week.

    Is there a way to export these jobs to excel than copy paste.

    also there are only 100 jobs per page (any way to increase this) not really user friendly ?

    Regards,

    Parag


    Monday, May 21, 2012 8:23 AM

All replies

  • Hi Parag--

    There is no out of box way to export the queue jobs data from Manage queue jobs, You can select the grid all columns & paste in excel. Another automated way is to use the powershell commands & run the scripts to automatically export in a format.

    Please see Paul's blog which has the step by step with script.
    http://pwmather.wordpress.com/2012/03/05/projectserver-2010-2007-high-level-audit-export-via-powershell-msproject-ps2010-epm/

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Monday, May 21, 2012 9:03 AM
  • Hi Amit,

    Thanks. I followed the your link and its not really what I am looking for.

    The output is different than what we get in manage queue.

    the columns are totally different.,

    Regards,

    Parag

    Monday, May 21, 2012 11:16 AM
  • Hi Parag,

    I understand that but that was just getting the data but if you are looking for the similar columns/data, I would say to have a custom solution to get it.
    Two Options:
    1. I have used the Project-Queue Report & Timesheet Queue Report in SSRS from project Server 2007 Report pack 2 (Management reports) , Hope it should work with few changes on PS2010 too.
    2. Write a PSI application to get the data in a grid with Export to excel functionality.
    http://msdn.microsoft.com/en-us/library/websvcqueuesystem_di_pj14mref
    http://msdn.microsoft.com/en-us/library/websvcqueuesystem.queuestatusdataset_di_pj14mref
    Read All job status: -Gets the status of all jobs of the specified types and states from the Project Server Queuing Service.
    [SoapDocumentMethodAttribute("http://schemas.microsoft.com/office/project/server/webservices/QueueSystem/ReadAllJobStatus", RequestNamespace = "http://schemas.microsoft.com/office/project/server/webservices/QueueSystem/", 
    	ResponseNamespace = "http://schemas.microsoft.com/office/project/server/webservices/QueueSystem/", 
    	Use = SoapBindingUse.Literal, ParameterStyle = SoapParameterStyle.Wrapped)]
    public QueueStatusDataSet ReadAllJobStatus(
    	JobState[] jobStates,
    	QueueMsgType[] messageTypes,
    	DateTime fromDate,
    	DateTime toDate,
    	int maxRows,
    	bool includeWaitTime,
    	SortColumn sortColumn,
    	SortOrder sortOrder
    )
    Hope this helps.




    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82



    Monday, May 21, 2012 11:32 AM