cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Level 7
Report Inappropriate Content
Message 11 of 19

Re: RE: Query to find Client Tasks?

Greg, you are my hero, thanks a million!

Highlighted
Level 10
Report Inappropriate Content
Message 12 of 19

Re: RE: Query to find Client Tasks?

Hey.

Such a query seems to be very useful, but i don't get.

Could someone please tell me the exact steps what i have to do to find a task like "RSD Sensor installieren" - would be great!

THX

serc09

PS: using ePO 4.5

Highlighted

Re: RE: Query to find Client Tasks?

If that is the specific task you're looking for you'd just have to change the 'taskname' variable (line bolded below) like this:

select TaskName, Nodename from epotask, epoleafnode, epocomputerproperties
where
epotask.parentid = epoleafnode.autoid
and
epoleafnode.autoid = epocomputerproperties.parentid
and
taskname like 'RSD Sensor installieren'
order by nodename

Andrew

Highlighted
Level 10
Report Inappropriate Content
Message 14 of 19

Re: RE: Query to find Client Tasks?

Ok - but what do I do with those things like:

select TaskName, Nodename from epotask, epoleafnode, epocomputerproperties
where
epotask.parentid = epoleafnode.autoid
and
epoleafnode.autoid = epocomputerproperties.parentid
and
taskname like 'RSD Sensor installieren'
order by nodename


???

serc

Highlighted
Level 12
Report Inappropriate Content
Message 15 of 19

Re: RE: Query to find Client Tasks?

This is a SQL script and needs to be run through SQL Management Studio.

Highlighted
Level 10
Report Inappropriate Content
Message 16 of 19

Re: RE: Query to find Client Tasks?

Ok. that changes everything.

No way to do so via ePO query?

Highlighted
Level 12
Report Inappropriate Content
Message 17 of 19

Re: RE: Query to find Client Tasks?

Unfortunately no, this is your best option.

Highlighted
Level 15
Report Inappropriate Content
Message 18 of 19

Re: RE: Query to find Client Tasks?

Thanks for solution. Its help me with a bit of house keeping on our tasks.

However, for anyone else reading this post, i did manage to get the SQL query to run through MS Access and an ODBC link to the EPO DB instead of using SQL Management Studio.

For the more advanced users out there, below is a quick and (very) dirty command line script which will extract just 'single system' tasks. Replace <your database> with the name of your epo database (normally ePO4_<servername> ) and run it from the command prompt on your epo server. Note: only tested on EPO version 4.0 & 4.5.

osql -E -S localhost\eposerver -d <your database> -Q "select TaskName, Nodename from epotask, epoleafnode, epocomputerproperties where epotask.parentid = epoleafnode.autoid and epotask.parentType="1" and epoleafnode.autoid = epocomputerproperties.parentid order by nodename"

Highlighted

Re: RE: Query to find Client Tasks?

Is it just me, or does it seem really stupid that it is not possible to list all client tasks that have been created? Thank you for the SQL code though. I am about to give it a go.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community