Unused computers - PDQ Inventory

Comments

14 comments

  • Mike B.

    Hi Frank,

    If I'm understanding your question correctly, I don't think there is a way to do "very little" in any fashion, usually your looking at last known connection/online dates.

    Perhaps more of what you are looking for would be clean up your stale computers in active directory manually or my preferred PowerShell depending on the size of your organization, then inside of PDQ Inventory go into the Active Directory section and Sync with AD without Syncing disabled computers.

    Hopefully this helps or at least leads you into the right direction!

    0
    Comment actions Permalink
  • Stephen Valdinger

    I think I see what he's wanting to get after. I don't believe the machines being stale in AD is the issue, I think he is trying to see if he can pinpoint some machines that are under-utilized in his environment so that he can repurpose them in some other area.

     

    That being said a SQL Report that pulls out the Computer's Name, Update, and Last Successful Scan date is what I'm going to say he is looking for. 

     

    Is this correct, Frank?

    0
    Comment actions Permalink
  • Mike B.

    If that's the case that would be easy as that information is already displayed in PDQ Inventory.

    0
    Comment actions Permalink
  • Stephen Valdinger

    I concur, we just need to push him in that direction and help with the SQL if he needs it :)

    0
    Comment actions Permalink
  • Mike B.

    What SQL help? Are we talking about the Last Successful Scan Date already displayed?

    Attached screenshot.

    0
    Comment actions Permalink
  • Stephen Valdinger

    Ha, look at that. Sorry, had a brain fart. Forgot all that info was displayed right in the collection! Yes, this is incredibly easy information to get at then.

    0
    Comment actions Permalink
  • SelfMan

    There might be a way to calculate the total uptime, but it will need some programmer skilz ;-) and a NOT cleaned event log.

    When the computer starts the EventLog fires event 6005 - with The Event log service was started. Then later few times 6013 - The system uptime is xxxxx seconds.And finaly 6006 - The Event log service was stopped.

    By calculating the time between event 6005 a 6006 you get the uptime for the period the computer was running. (it wont tell you if it was used, but hey... who cares ;-) its about the uptime.)

    A help might be the Exploring Event Logs with Get-EventLog article.

    This script can be deployed by PDQ Deploy nad the result stored in a text file in a file share.
    AFAIK - PDQ Inventory does not collect this information (yet).

    0
    Comment actions Permalink
  • Mike B.

    Total uptime is displayed along with Successful Scan Date.

    Attached Screenshot.

    0
    Comment actions Permalink
  • SelfMan

    Mike, I don't think thats the Total uptime of a computer. Its the uptime at the time of the scan.
    Something you can see in the Task manager's "Performance" tab.

    If there is a restart after the scan the remaining time would be lost. The new scan will return a value since the reboot.

    0
    Comment actions Permalink
  • Mike B.

    Ah I understand the question now.

    Personally I'm not sure how to determine that through CMD or PS but I do know there are a few free software programs out there that have total uptime listed. No programming required =)

    0
    Comment actions Permalink
  • SelfMan

    Ok, I might get my nuts kicked, but this will help you to archieve what you need to do.

    Download WinAudit (its freeware), load it in to PDQ Deploy and set the following parameters:

    /r=U /f=\\server\share\uptime-audit-%computername%.csv

    When you deploy this task, a buch of scv files will get created which you can merge later and load in to Excel where you can perfome some Excel-ent magic.

    Other allowed file types are RTF, CSV2 and HTML There is also an information about the date since the data is available and the result calculated..

    0
    Comment actions Permalink
  • Frank

    Hello all !

     I see that my question leads to debate :)

     


    Yes, you have understood.
    In our institute we would like to avoid buying new machines because here the employees are capricious and want a new pc for a yes or a no.

    I want to locate machines that are underutilized and remove them from the computer pool for later re-use.

    I'm sorry for my bad english: /
     
    Anyway, thanks for your answers !
    0
    Comment actions Permalink
  • Sobo

    Is there a solution to this?  I was just tasked to locate underutilized Windows 10 workstations and pull them back if need be, to re purpose.  Thanks for any info!

    0
    Comment actions Permalink
  • Colby Bouma

    @Sobo: This forum has been deprecated. Please post your question to https://community.pdq.com

     

    It looks like this particular thread got moved here: https://community.pdq.com/posts/2516-unused-computers---pdq-inventory

    0
    Comment actions Permalink

Please sign in to leave a comment.