I am currently working on a report to show Client Images when they were backed up, when they expire, the name of the image, and the SLP Job they were part of, . So far I have te following shown below...SELECT DISTINCT domain_image.id AS "Image ID"
,...
I need help writing a query that I assume needs a join or inner join that I cannot figure out, and my SQL knowledge is to be desired. So here is what I am trying to do...First the tables and columns.
Tables and Columns that have the data I need.
...
Greetings,
I have a business need to generate reports for each of my admin teams by Client OS, RHEL, AIX, HP-UX, Windows, etc...etc...
The report would include the following columns.
-------------------------------------------------------------...
Situation - We have the following policy's with the following schedules.
Policy: sql_Transaction_Log
Schedule: Full_Top_Hour - Starts @ 12:00:00
Full_Bottom_Hour - Starts @ 12:30:00
The jobs do not start at these times however ...
Disregard, I figured it out, I needed to remove the line "domain_JobArchive.statusCode not in (0,1) " with the new case. And Violla!...
Below is the final query that gives you VMguest backup report with Operating System.
SELECT domain_Policy....
areznik,
Thanks for the reply, that definitly helped out, also helped me to change up my CASE statement a bit.
select
domain_Policy.name as "Policy",
domain_client.name as "VM Guest",
adjust_timestamp(domain_JobArchive.startTime,...
So I tried that and it seems to return the same values as my case statement for Job Status
Policy
VM Guest
Job Start Time
Job End Time
Virtual OS
Throughput (KB/Sec)
Backup
Job Status (Com...
My last post noted I was stuck getting the desired results. My issue is trying to join the tables to get the desired results, after that last post the thread was locked.
You said shout if I got stuck, and I have :)
Well I might just be stuck, here is what I got. But I seem to be stuck trying to snatch the data I want in my query?
NOTE: I used TOP 100 for quick results only.
select
TOP 100 START AT 1 domain_Policy.name as "Policy",
domain_client.name as "...