Registered member login:
Register Now
Altirigos » Altiris Administrators » SQL » SQL Query for Jobs created in X amount of time

» Current Poll
Do you leave the Aclient enabled?
YES - 82.20%
97 Votes
NO - 17.80%
21 Votes
Total Votes: 118
You may not vote on this poll.
» View Poll Results
» Discuss This Poll
» This Poll Has 12 Replies
» Stats
Members: 9,443
Threads: 11,717
Posts: 55,149
Top Poster: Nick (4,979)
Welcome our newest member, lpesek
» Online Users: 32
1 members and 31 guests
thismre
Most users online at once 294, 06-30-2007 at 01:24 PM.
» March 2010
S M T W T F S
28 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 123
Reply
Display Modes
Search this Thread
Thread Tools
Old 11-20-2008, 03:36 AM   #1 (permalink)
 
Status: Altiris Admin
Join Date: 09-08-2006
Location: New Jersey
Posts: 87


SQL Query for Jobs created in X amount of time
I am trying to figure out a way I can see jobs CREATED in a certain amount of time but I dont see any sort of table or column with creation date in it. Any ideas?
s0n- is offline   Reply With Quote
Old 11-20-2008, 05:03 AM   #2 (permalink)
 
Status: Junior Altiris Admin
Join Date: 01-16-2008
Location: Kansas City
Posts: 25


HD_workitem_current_view.[workitem_created_on]
__________________
______________________
Chris Crowell
Murphy-Hoffman Company
Kansas City, MO
chris.crowell is offline   Reply With Quote
Old 11-20-2008, 09:53 AM   #3 (permalink)
 
Status: Altiris Admin
Join Date: 09-08-2006
Location: New Jersey
Posts: 87


Quote:
Originally Posted by chris.crowell View Post
HD_workitem_current_view.[workitem_created_on]

Is this a Helpdesk query? I am looking for a DS job on the express database
s0n- is offline   Reply With Quote
Old 11-20-2008, 09:59 AM   #4 (permalink)
 
Status: Junior Altiris Admin
Join Date: 01-16-2008
Location: Kansas City
Posts: 25


Sorry, didn't read your post thoroughly and I had helpdesk on the mind.
__________________
______________________
Chris Crowell
Murphy-Hoffman Company
Kansas City, MO
chris.crowell is offline   Reply With Quote
Old 11-20-2008, 10:06 AM   #5 (permalink)
 
Status: Altiris Admin
Join Date: 09-08-2006
Location: New Jersey
Posts: 87


Quote:
Originally Posted by chris.crowell View Post
Sorry, didn't read your post thoroughly and I had helpdesk on the mind.
No problem, just thought it looked weird ha
s0n- is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Powered by vBadvanced CMPS v3.0 RC2

All times are GMT -4. The time now is 11:30 PM.

Contact Us - Altirigos - Archive - Top

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
vB.Sponsors
Altirigos
Copyright ©2000 - 2008, Altirigos.com. All Rights Reserved. No Duplication Permitted!
vBulletin skin created by CompletevB.com