Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

How to get policy start times in readable format in custom SQL query in OpsCenter

Created: 12 Nov 2012 • Updated: 13 Nov 2012 | 3 comments
This issue has been solved. See solution.

Hi guys. I would like to know if any of you could help me with a custom SQL query for OpsCenter. I am doing a simple query like this: select * from domain_ScheduledJob where policyname like 'SQL%' but unfortunately the scheduledTime and startTime columns display the time as a series of numbers like  135710172000000000. Is there a way to convert that in a readable format for the WHOLE query, not just for a single entry that I would convert manually? Basically I was asked to show a report on my policies for SQL backups that would show the date and start times. If someone has a better idea than my custom SQL query, please let me know! :)

Thanks!

Christian

Discussion Filed Under:

Comments 3 CommentsJump to latest comment

MilesVScott's picture

I have tried a few options but I cant get the Syntax to function properly. Here is a good article on the CAST/CONVERT functions in Sybase.

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

C_Moisan's picture

Thanks for your answer, I found a much better way to get what I need. I found another report that gives me the scheduled jobs and the start time in human readable format. The report is under Job Activity --> Planning Activity --> Scheduled Job --> All jobs.

SOLUTION
MilesVScott's picture

All the better. Why reinvent the wheel, right?

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist