Find out when a workarea is updated

Are you talking about a property under the Properties tab when you right-click the root folder a Work Area, Select Properties and then click the Properties tab? If so all those properties are attributes created by the ProjectWise admin and (unless they've done some backed database magic) don't update automatically.

If you're talking about the UpdateDateTime of just the general Folder properties (the UpdateDateTime property returned by Get-PWFolders cmdlet) as near as I can figure the only thing that causes that property to update is changing one of the properties on that folder (Description, a work area property, etc...). Adding/modifying/deleteing files or folders inside that folder does not update it.

There is a cmdlet Get-PWFolderTreeMaxFileUpdateDate that looks like it should return this info but in my testing it seems wrong? I tested it on a folder where I had updated files today and it's returning a date over a year old.

Get-PWRichProjectMaxUpdateDate also seems like it should do it, but I'm not exactly sure how that operates. I pass it a folder path to a richproject and returns info for every rich project in the datasource (the dates actually look correct to me though, unlike the other one).

If you want to write your own:

$pwDocs = Get-PWDocumentsBySearch -FolderPath 'path\to\folder'
$latest = ($pwDocs | Sort -Descending DocumentUpdateDate | Select-Object -First 1).DocumentUpdateDate

That will probably be slow and suck up a ton of memory for really large folder structures. although, hmmm, not sure this'll be faster but should free up the memory quicker:

$latest = (Get-PWDocumentsBySearch -FolderPath 'path\to\folder').DocumentUpdateDate | Sort -Descending | Select -First 1

Thank you Kevin i find your respond very helpful. So there is no cmdlet in powershell which indicate if an attribute of a work area has been updated?

Oh, hmmm, I'm not seeing a way to tell when one of the Work Area properties is updated. It appears UpdateDateTime only updates when any of the non-WorkArea properties is changed. Perhaps someone else is aware of a way.

Alright thank you Kevin

The best I came up with using SSMS to tell if an attribute of a work area has been updated is:

SELECT * FROM sys.tables
WHERE [name] like '%'
ORDER BY [modify_date] desc

Replace % with the table name of your Work Area.

It doesn't tell you what was updated just that something was. Not very helpful. I also don't see anything in the audit trail when a WA attribute is updated.