Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum How To: Export ProjectWise Datasource Statistics To Excel Using PowerShell
    • Sign In

    • Replies 2 replies
    • Subscribers 65 subscribers
    • Views 1098 views
    • Users 0 members are here
    • powershell
    • ProjectWise
    • ProjectWise PowerShell Modules

    How To: Export ProjectWise Datasource Statistics To Excel Using PowerShell

    Brian Flaherty
    Offline Brian Flaherty over 5 years ago

    I have added another post to my PowerShell and ProjectWise blog which steps through the process of exporting out ProjectWise Datasource Statistics information to an Excel spreadsheet.

    http://powerwisescripting.blog/2018/10/10/how-to-export-projectwise-datasource-statistics-to-excel-using-powershell

    Please check it out.  Hopefully you find this useful.

    Cheers,

    Brian

    • Sign in to reply
    • Cancel
    • Kevin van Haaren
      Offline Kevin van Haaren Thu, Oct 11 2018 11:49 AM

      Thanks, I write our datasource statistics to a SQL table so I can maintain a historical record, but I did steal your info on New-XLSXWorkbook to use with Get-PWDocumentReportDataTable. perhaps an explanation of that cmdlet and how the audit trail stuff works on that command?

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Cancel
    • Brian Flaherty
      Offline Brian Flaherty Thu, Oct 11 2018 3:20 PM in reply to Kevin van Haaren

      I like the idea of putting the statistics into a SQL table. That is my preference as well. What info would you like to know about the New-XLSXWorkbook?  Not sure what you are referring to with the Audit Trail.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • 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