PDQ Inventory - Value Owner

Comments

9 comments

  • Luke Nichols

    Mix,

    Where are you seeing this value? I do not see it in PDQ inventory.

    Can you please share a screenshot that is not cropped so heavily so that I can get a better idea of where in the interface you encountered this?

    1
    Comment actions Permalink
  • Mix Channel

    Hi

    For example I have created a "inventory" to find out everyone who has Google Chrome installed.

    I notes there is field called Owner

     

    I would like to try to take advantage of that.

    1
    Comment actions Permalink
  • Luke Nichols

    Mix,

    Ok, now I understand. I do not have an "owner" field available to me, but I do have "Current User." It could be that these two fields are the same, but it is labeled differently in your PDQ due to version differences or language differences.

    Assuming that your "owner" field is the same as my "current user" field, it is used to display who is currently logged into a computer. Or at least, who was currently logged into the computer during its last scan.

    1
    Comment actions Permalink
  • Mix Channel

    I have Current User and thats great it says who is logged in.

    But that will change if someone else logges in or a administrator.
    So thats why I want to use field Owner.

    If its a register key for exampel, I could maybe build powershell script force user register the computer.
    So that key "value" will be created.

    So that value will be present for PDQ Inventory.

     

    1
    Comment actions Permalink
  • Luke Nichols

    Sorry, but I do not see an "owner" field in my PDQ Inventory columns anywhere. It is not available to add to the columns display. I do not see it my computers' info tables, either.

    Maybe someone else can chime in who knows more about it than I do.

    1
    Comment actions Permalink
  • Colby Bouma

    That is probably a Custom Field that someone else set up. You can see which Custom Fields you have by navigating to Options --> Custom Fields. There is also a Custom Fields tab on the Computer window (the window that opens when you double-click on a computer).

    1
    Comment actions Permalink
  • Mix Channel

    Hi

    Thank you everyone, I learned new things about PDQ by this post
    Owner is Text type that someone had created.

    :)

    I managed to import CSV file with Powershell.
    I am now one step closer to my goal of automation.


    If anyone wonder how or what I did

    ------------------------------------------------------

    I have CSV file that contains this

    Name,Owner
    Computername,Username

    --------------------------------------------------------

    Script that will be running on PDQ Inventory Server

    $TempFile = "\\where_csv_file_is\owner.csv"
    $Computer = "Name"
    $CustomFieldName = "Owner"
    $CustomFieldType = "String"
    PDQInventory.exe ImportCustomFields -FileName $TempFile -ComputerColumn $Computer -CustomFields "$CustomFieldName=$CustomFieldName" -AllowOverwrite

     

    1
    Comment actions Permalink
  • Dan Winchester

    Mix Channel

    When you say you'll be running this script on the PDQ Inventory Server, how do you plan to accomplish this?  I'm brand new to PDQ and also have a need to display the Primary Owner (avg of the last x number of logins) of a machine.  Here's what it used to look like on my former management software...thank you

     

    1
    Comment actions Permalink
  • Mix Channel

    Hi Dan

    This is how I solved it. 

    First you need Text field called Owner
    And field called Name (that contains computer name)


    Over to the code
    Its not pretty but works.


    1. 
    I Created PDQ package that will
    That will place *.bat file in C:\ProgramData\Microsoft\Windows\Start Menu\Programs\StartUp

    And place a powershell file where you will point to in the bat fil that contain text below
    PowerShell.exe -NoLogo -NonInteractive -NoProfile -ExecutionPolicy Bypass "C:\folder\powershellFile.ps1"

    in that powershell file
    Entire file is almost 100 row due to GUI and funcation and checks
    if you want entire file let me know, I will try rush publish it on 08gamer.com
    The importend part in the powershell file

    #Hostname to get the computer name
    #WhoAmI to get the username of the person login
    $employees = @($Hostname+","+$WhoAmI)

    #Adds a new row in a Existing csv file, this file needs to somewhere your PDQ can reach it.
    $employees | foreach { Add-Content -Path \\Fileshare\ComputerOwner.csv -Value $_ }

    ------------------------------------------

    On the PDQ server (avoid to be login in server if its possible seems like you get prompt)

    Has a schedule task that runs *bat file
    That contains

    PowerShell.exe -NoLogo -NonInteractive -NoProfile -ExecutionPolicy Bypass "C:\folder\powershellFile.ps1"

     

    That powershell file contains

    $TempFile = "\\Fileshare\ComputerOwner.csv"
    $Computer = "Name"
    $CustomFieldName = "Owner"
    $CustomFieldType = "String" # Valid types - Boolean, String, Integer, Date, or DateTime
    PDQInventory.exe ImportCustomFields -FileName $TempFile -ComputerColumn $Computer -CustomFields "$CustomFieldName=$CustomFieldName" -AllowOverwrite

    #Script will wait 30 sec so import can be done
    Start-Sleep -Seconds 30

    #Then remove csv file and create a new one so no old information will be there (and GDPR will give me a break)
    Remove-Item –path \\Fileshare\ComputerOwner.csv
    Add-Content -Path \\Fileshare\ComputerOwner.csv -Value 'Name,Owner'

     

    I Hope this information can be to some help for you

     

    0
    Comment actions Permalink

Please sign in to leave a comment.