Register
FAQ
Members List
Calendar
Arcade
Search
Today's Posts
Mark Forums Read
Video
Registered member login:
Altirigos
»
Altiris Administrators
»
SQL
»
SQL Query for Jobs created in X amount of time
» Site Navigation
»
Homepage
»
Altirigos Forums
»
File Repository
»
Knowledge Base
»
Altiris Forums
»
Altiris Knowledge Base
»
Webmail
»
Training Videos
»
Altiris based IRC Chat
» Current Poll
What version of DS will you use to migrate to Windows 7?
DS 6.x - 77.50%
DS 7.x - 22.50%
Other - 0%
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
28
29
30
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
Display Modes
Search this Thread
Thread Tools
11-20-2008, 02:36 AM
#
1
(
permalink
)
s0n-
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?
11-20-2008, 04:03 AM
#
2
(
permalink
)
chris.crowell
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
11-20-2008, 08:53 AM
#
3
(
permalink
)
s0n-
Status:
Altiris Admin
Join Date:
09-08-2006
Location:
New Jersey
Posts:
79
Quote:
Originally Posted by
chris.crowell
HD_workitem_current_view.[workitem_created_on]
Is this a Helpdesk query? I am looking for a DS job on the express database
11-20-2008, 08:59 AM
#
4
(
permalink
)
chris.crowell
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
11-20-2008, 09:06 AM
#
5
(
permalink
)
s0n-
Status:
Altiris Admin
Join Date:
09-08-2006
Location:
New Jersey
Posts:
79
Quote:
Originally Posted by
chris.crowell
Sorry, didn't read your post thoroughly and I had helpdesk on the mind.
No problem, just thought it looked weird ha
«
Previous Thread
|
Next Thread
»
Currently Active Users Viewing This Thread: 1
(0 members and 1 guests)
Thread Tools
Search this Thread
Show Printable Version
Email this Page
Search this Thread
:
Advanced Search
Display Modes
Linear Mode
Switch to Hybrid Mode
Switch to Threaded 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
LinkBack
LinkBack URL
About LinkBacks
Bookmark & Share
Digg this Thread!
Add Thread to del.icio.us
Powered by
vBadvanced
CMPS v3.0 RC2
All times are GMT -4. The time now is
07:54 PM
.
-- Deutsch (Du)
-- Deutsch (Sie)
-- English (US)
-- Français
-- Italiano (IT)
-- Spanish
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