Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Find out when a workarea is updated
    • Sign In

    • State Not Answered
    • Replies 7 replies
    • Subscribers 67 subscribers
    • Views 542 views
    • Users 0 members are here
    • Update
    • workarea

    Find out when a workarea is updated

    Michel-Ange Doubogan
    Offline Michel-Ange Doubogan 11 months ago

    Hi everyone,

    Does the workarea property 'updatedatetime' indicate if a file or a folder in a workarea is updated? I'm trying to find out if any file or folder in a workarea is updated. How can i catch this behaviour?

    Thanks.

    • Sign in to reply
    • Cancel
    • Michel-Ange Doubogan
      0 Offline Michel-Ange Doubogan Wed, Nov 9 2022 11:43 AM in reply to Brian Flaherty

      I used the cmdlet Get-PWFolderAuditTrailRecords but it doesn't give an update date in the output.

      I also got this warning message : 

      WARNING: Failed to retrieved document audit trail information for documents in project.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Brian Flaherty
      0 Offline Brian Flaherty Thu, Oct 6 2022 1:47 PM

      You could query the audit trail table to look for any updates.  

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Dave Cole
      0 Offline Dave Cole Thu, Oct 6 2022 1:14 PM in reply to Michel-Ange Doubogan

      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.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Michel-Ange Doubogan
      0 Offline Michel-Ange Doubogan Tue, Sep 27 2022 1:25 PM in reply to Kevin van Haaren

      Alright thank you Kevin

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Kevin van Haaren
      0 Offline Kevin van Haaren Mon, Sep 26 2022 3:52 PM in reply to Michel-Ange Doubogan

      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.

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    >

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies