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

» Current Poll
What version of DS will you use to migrate to Windows 7?
DS 6.x - 77.50%
31 Votes
DS 7.x - 22.50%
9 Votes
Other - 0%
0 Votes
Total Votes: 40
You may not vote on this poll.
» View Poll Results
» Discuss This Poll
» This Poll Has 6 Replies
» Stats
Members: 8,068
Threads: 10,728
Posts: 51,477
Top Poster: Nick (4,939)
Welcome our newest member, stevej
» Online Users: 12
0 members and 12 guests
No Members online
Most users online at once 294, 06-30-2007 at 12:24 PM.
» July 2009
S M T W T F S
282930 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 1
Reply
Display Modes
Search this Thread
Thread Tools
Old 11-20-2008, 02:36 AM   #1 (permalink)
 
Status: Altiris Admin
Join Date: 09-08-2006
Location: New Jersey
Posts: 79


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, 04:03 AM   #2 (permalink)
 
Status: Junior Altiris Admin
Join Date: 01-16-2008
Location: Kansas City
Posts: 19


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, 08:53 AM   #3 (permalink)
 
Status: Altiris Admin
Join Date: 09-08-2006
Location: New Jersey
Posts: 79


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, 08:59 AM   #4 (permalink)
 
Status: Junior Altiris Admin
Join Date: 01-16-2008
Location: Kansas City
Posts: 19


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, 09:06 AM   #5 (permalink)
 
Status: Altiris Admin
Join Date: 09-08-2006
Location: New Jersey
Posts: 79


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 07:54 PM.

Contact Us - Altirigos - Archive - Top

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, 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