Hi All,
I am running below query to get SLP images pending for date wise for last 3 days
SQL Query:
select b.imageid,DATEFORMAT(cast(UTCBigintToNOMTime(a.writeStartTime) as DATETIME), 'yyyy-mm-dd') as "Write Time",b.copystate,b.copytype,cs.name CopyState,ut.name CopyType from domain_slpimage a
join domain_slpimagecopy b on a.id=b.imageid
JOIN lookup_CopyState CS ON CS.id = b.copystate
join lookup_StorageServiceUsageType ut on ut.id = b.copytype
where b.copytype in (1,3) and b.copystate in (1,2) and DATEDIFF(day,UTCBigIntToNomTime(a.writeStartTime), GETDATE()) <=3
Output.
| imageid | Write Time | copystate | copytype | CopyState | CopyType |
| Image Name1 | 20/08/2016 | 1 | 1 | Not Started | Duplication |
| Image Name2 | 22/08/2016 | 1 | 1 | Not Started | Duplication |
Same query is working fine for my DR server, but in primary am getting "An unknown exception has occurred".
Kindly help on this.
