Jump to content

Dave M

Members
  • Content Count

    14
  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Agent Count
    < 500 Agents

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    It works! THANK YOU For anyone else trying this, You need to put in companyid+publickey:privatekey at https://www.base64encode.org/, then paste the full output in the parameter.
  2. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    @Joe.McCall I have registered and logged into https://developer.connectwise.com. Could you please point me in the right direction and let me know where I can find the API key, and how to implement this in Automate? I keep getting: Something went wrong. The remote server returned an error: (400) Bad Request. Much appreciated & TY Start SSI\Testing\CWA - SQL Function - Update WarrantyExpiration in Manage IF True Time Taken: 1.1406072 L1 Execute Script Time Taken: 1.1406072 L3 Script Log Message Message (P1): Woooo - Something went wrong. The remote server returned an error: (400) Bad Request. Time Taken: 15.1879583 Start CWA - SQL Function - Update WarrantyExpiration in Manage IF True Time Taken: 1.1406072 L1 Execute Script Time Taken: 1.1406072 L3 Script Log Message Message (P1): Something went wrong. The remote server returned an error: (400) Bad Request. Time Taken: 15.1879583
  3. Dave M

    Email a Uploaded File

    I think that would be problematic because I believe there is a link to it in the database.
  4. Dave M

    Email a Uploaded File

    @troms I tried getting the same exact thing to work before and gave up. Needless to say at least yours is getting some traction and hopefully a working script!
  5. @mike_judd, Thank you but as you mentioned, this is not exactly it. I'd want an alert/ticket because if the agent is there, odds are other things it installs (Ninite, AV, ETC) are back.
  6. Is it possible to setup an alert or ticket, based on a list of blacklisted MAC addresses? The idea is if a system is retired and deleted, and comes back, you get alerted about it rather than it just sitting there.
  7. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    @DarrenDK That you for the update! The Ps script now runs fine and produces results in ISE. However, I don't see anything updates in Manage. I have double checked to make sure my mapping is OK, manually ran the script against a machine, and forced an asset sync. Where else can I look to troubleshoot? I was able to find this in the executed script log, although it runs fine in ISE: # Warranty Lookup Result Trimming SerialNumbers Updating Dell Warranties No Dell computers missing warranty Updating Lenovo Warranties Submitting computers to Lenovo API: 1037921101087 New-Object : Cannot find type [â?TypeName PSObject â?Prop]: verify that the assembly containing this type is loaded. At C:\Windows\Temp\9cffbb28-1850-11e9-bdd6-00155d006e00.ps1:229 char:21 + ... $WarrantyInfo = New-Object â?"TypeName PSObject â?"Prop $properties + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidType: (:) [New-Object], PSArgumentExcepti on + FullyQualifiedErrorId : TypeNotFound,Microsoft.PowerShell.Commands.NewOb jectCommand 1/14/2019 6:03:46 PM ComputerID Hidden_ComputerID
  8. Do you know what specific permission the user needs on the Automate side? I can't seem to get any passwords to show for a specific user unless I make his user class include superadmin.
  9. This is absolutely amazing and awesome! I even have it multihomed between our standalone Connect server and the one that runs with automate. Both work like a charm! Now all we need is logging who used it and it's a mini snifftheglue!
  10. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    Grrr.. no matter what I do I can't get it passed this! Updating Dell Warranties You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull
  11. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    I updated 348 to "Update-WarrantyInLabTech -ComputerID $_.ComputerID -ShipDate $ShipDate -WarrantyEndDate $EndDate". and I now get: Updating Lenovo Warranties Submitting computers to Lenovo API: PF0ZZLCL Updating ComputerID: 54 ShipDate: 03/06/2018 00:00:00 EndDate: 05/13/2019 00:00:00 Updating HP Warranties However it is still not showing anything in Manage. I'm also still getting the error on line:259 char:8, which is expected as nothing has changed.
  12. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    Thank you! Unfortunately I'm still not having any luck. I ran the script on the server with ISE and I get the below errors. Any pointers in the right direction is appreciated. #Get-DellWarrantyInfo -ServiceTag @("*******","*******") -APIKey $DellAPIKey2015 Trimming SerialNumbers Updating Dell Warranties You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At line:259 char:8 + New-Object psobject -Property @{"WarrantyEndDate"=[DateTime]:: ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull Updating ComputerID: 92 ShipDate: 12/07/2018 00:00:00 EndDate: 12/06/2021 00:00:00 Updating ComputerID: 91 ShipDate: 12/07/2018 00:00:00 EndDate: 12/06/2021 00:00:00 Updating Lenovo Warranties Submitting computers to Lenovo API: ******* Update-WarrantyInLabTech : A parameter cannot be found that matches parameter name 'EndDate'. At line:348 char:84 + ... abTech -ComputerID $_.ComputerID -ShipDate $ShipDate -EndDate $EndDat ... + ~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [Update-WarrantyInLabTech], ParameterBindingException + FullyQualifiedErrorId : NamedParameterNotFound,Update-WarrantyInLabTech I also checked Computers with ID 92 and 92, and they do not have the information populated in manage.
  13. Dave M

    Computer Warranty Updater (HP/Dell/Lenovo)

    @DarrenDK this looks to be an awesome script, and a well written howto! Thank you. I am however having some issues when I run it, and results are not making it into manage. When the script runs, it comes back with the following in the log: # Warranty Lookup Result Trimming SerialNumbers Updating Dell Warranties % : You cannot call a method on a null-valued expression. At C:\Windows\Temp\2e98f56d-fe14-11e8-afa9-00155d006e00.ps1:257 char:45 + $Warranties = $XML.AssetWarrantyResponse | %{ + ~~ + CategoryInfo : InvalidOperation: (:) [ForEach-Object], RuntimeE xception + FullyQualifiedErrorId : InvokeMethodOnNull,Microsoft.PowerShell.Commands .ForEachObjectCommand Any ideas on what I could be doing wrong? I also noticed the function script (ImmyBot\Function Scripts - Core\Run-PowershellOnLTServer) refers to immense.net. What is the function doing when it does this and is it necessary to run?
×