Deployment Solution

 View Only

  • 1.  Need query to create token from Task server or Package server

    Posted Oct 14, 2014 01:21 AM

    I need a query that I can use to create a token for the task server that the machine has most recently been connected to as of last inventory update.  I have seed several refrences to that being done post 7.X but I could not find the table or view that has that information for my life.   

      Basically I want a query like this:

    Select
      vComputer.Server
    From
      vComputer
    Where
      vComputer.Guid = 'xxxxxxxxxxxxxxxxxxxxxxxxx'
     

    That finds TaskServer instead of Server.  Only I don't know where in the database the taskserver field is stored.  I would expect it to be called Task_server, or similiar or Package_Server or simliar....

    Hope that makes sense.   Thank you all! 



  • 2.  RE: Need query to create token from Task server or Package server
    Best Answer

    Broadcom Partner
    Posted Oct 14, 2014 07:56 AM

    Hi schuttwm,

    1) use this SQL Query for Task Server as Token:

    select c.name from TaskTargetDeviceCache vc left outer join Inv_Client_Task_Resources ctr on ctr._ResourceGuid = vc.Guid And vc.Guid = '%COMPUTERID%' left outer join Inv_Client_Task_Servers cts on cts.ClientTaskServerGuid = ctr.ClientTaskServerGuid Join vcomputer c on cts._ResourceGuid = c.guid

    Hope this helps..

    Network23



  • 3.  RE: Need query to create token from Task server or Package server

    Posted Oct 14, 2014 10:22 AM

    Works correctly as a straight query.  I will try it in a task soon.  Thank you very much!



  • 4.  RE: Need query to create token from Task server or Package server

    Broadcom Partner
    Posted Oct 16, 2014 05:06 AM

    Hi schuttwm,

    Glad to help!

    Are you able to create a Task Server Token with the SQL Query above?

    Please let me know if this solves your problem!

    Thanks

    Network23



  • 5.  RE: Need query to create token from Task server or Package server

    Posted Oct 16, 2014 09:36 AM

    Yes I have verified wit works!  Thank you very much for your time and energy.   Is there a way to mark your post as helpful (or similiar)?