cancel
Showing results for 
Search instead for 
Did you mean: 

Placeholders Files and thier Sizes and How Many

Mike_Reed
Level 4

Got a question about placeholder files. Is there anyway to find out on how many have been created on a target server and to find out their sizes and how much space they have consumed or saved. If we had to do a bulk recall would their be enough disk space to recall all of them is my question.

I know when a placeholder is created its 4kb in size. I need some sort of report on them for management.

Thanks Folks.

1 REPLY 1

plaudone1
Level 6
Employee

Hi Mike_Reed

Here is a query that should help. Run against the vault store database.  This will tell you what is archived, but not the size of what the placeholders would be if recalled.  It should be a higher estimate.  

-- START QUERY
DECLARE @Date1 datetime
DECLARE @Date2 datetime
DECLARE @ArchiveName Nvarchar(36)


--Modify parameters there to set date range and archive to check on
SET @Date1 = '2010-02-08'
SET @Date2 = GETDATE() --i.e Date range up to present time
SET @ArchiveName = NULL --Add an Archive Name to filter a particular archive


--Drop temp table if already exists
IF object_id('tempdb..#temp') is not NULL
BEGIN
Drop table #temp
END


SELECT
Archive.ArchiveName,
ArchivePoint.ArchivePointId,
@Date1 AS DateFrom, @Date2 as DateTo,
COUNT(*)Items,
SUM(ItemSize)/1024 AS DVSSize_MB,
SUM(OriginalSize)/1024/1024 AS OrignalSize_MB
FROM
EnterpriseVaultDirectory.dbo.Archive Archive
JOIN EnterpriseVaultDirectory.dbo.Root RT on Archive.rootidentity = RT.rootidentity
JOIN ArchivePoint on RT.VaultEntryId = ArchivePoint.ArchivePointId
JOIN Saveset on ArchivePoint.ArchivePointIdentity = Saveset.ArchivePointIdentity
JOIN SavesetProperty SP on Saveset.SavesetIdentity = SP.SavesetIdentity
WHERE
Saveset.ArchivedDate > @Date1
AND Saveset.ArchivedDate < @Date2
AND Archive.ArchiveName = ISNULL(@ArchiveName, Archive.ArchiveName)

GROUP BY
ArchiveName,
ArchivePoint.ArchivePointId

-- END QUERY 

Thanks,

Patrick