1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Need help creating a auto report that tells me all the new software in PDQ Deploy.

Avatar
Jordan Ekern

Hello,

I am trying to make a Report that will inform me of new versions of software that show up in PDQ Deploy package library? Is their way way this can be done? 

0

Comments

2 comments
Date Votes
  • Avatar
    Permanently deleted user

    I don't think you can do that within PDQ itself. You could use this PowerShell script. Just edit the $Email_Params and set up a daily job in Task Scheduler. I have not tested the email part of this yet, so hopefully it works :)

    $Timestamp_Yesterday = Get-Date -Format "yyyy-MM-dd HH:mm:ss" ( Get-Date ).AddDays(-1)
    $SQLite_EXE = "$env:SystemDrive\Program Files (x86)\Admin Arsenal\PDQ Inventory\sqlite3.exe"
    $Deploy_DB = "$env:SystemDrive\ProgramData\Admin Arsenal\PDQ Deploy\Database.db"
    $Query = "SELECT LibraryPackages.Name, LibraryPackageVersions.VersionNumber
        FROM LibraryPackages INNER JOIN LibraryPackageVersions USING (LibraryPackageId)
        WHERE LibraryPackageVersions.Created > Datetime('$Timestamp_Yesterday')
        ORDER BY LibraryPackages.Name;"

    $Results = & "$SQLite_EXE" "$Deploy_DB" -separator " - " "$Query"

    $Email_Params = @{
        To = "You@awesomecorp.org"
        From = "NewPackages@awesomecorp.org"
        Subject = "New PDQ Packages"
        Body = $Results
        SmtpServer = "mail.awesomecorp.org"
    }

    if ( $Results -ne $null ) {

        Send-MailMessage @Email_Params

    }
    0
  • Avatar
    Permanently deleted user

    Oh yeah, I forgot you can just follow this section of the forum or the PDQDeploy subreddit :)

    0