Get access/modified Date from sql

[dietmar]

Hi,

Is there a way to get those File Attribute Dates from the Server via SQL ?

Its about Data Management. ( or not *gg* )

I would like to know how many files/GB are stored on a filespace grouped by Access_Date (Year) .

The Idea is to find/show how many old Files which are still on FileSystem / Backup .

Best regards, Dietmar

 

[Trident]

Hi,

Will this do the task for you:

select cast(NODE_NAME as char(20)),cast(FILESPACE_NAME as char(20)),state,date(BACKUP_DATE),count(*),sum(ACTUAL_SIZE)/1024/1024/1024 as Gb from backups group by NODE_NAME,FILESPACE_NAME,state,date(BACKUP_DATE)

It can be tweaked.

Be warned, on a large system, this will take some time, and it will consume a lot of resources.

 

[dietmar]

Hi Trident,

I do not want (cannot use ) Backup_Date . ( Backup Table ) . I do need the real File Level Attribute Data from Files to do this. ( Access_Date from NTFS )

Thx, dietmar