Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


mr.wallstrom last won the day on May 9 2018

mr.wallstrom had the most liked content!

Community Reputation

2 Neutral

My Information

  • Agent Count
    Less than 100

Recent Profile Visitors

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

  1. All, I have edited my original picture post, to include a little more detail. Let me know if this isn't enough, and I'll crack it open and try to improve some more. Sorry for the delays! You can see from the start of this thread, I was one of the early ones trying to sort this out, and Darren was a huge help.
  2. Thank you, Dave. Yes, it was the v2 I downloaded. Thank goodness I've learned what I have so far... (with a lot of leads from here.) With the bulk of the idea and code that DID come through, I was able to rebuild it myself - looks almost identical to yours, so must be on the right track! We're running this in tandem with a scripted process to set BIOS pwd, enable it there, enable TPM, and finally enable Bitlocker, at least on Dell's. (Scripted and scheduled, but not 'automated'.)
  3. Thank you, DAVE! A true Hero. Can anyone else help with an importing issue here? I imported both files that Brenden posted, the SQL and the script. I don't see the new EDF fields showing up automatically anywhere... and when I open the script, I get an "Error loading script:Syntax error: Missing operand after 'b9c' operator." First time I opened it, it was a different operator listed, but it's now showing that one. I've only ever imported 1 thing before, so may have done it wrong?
  4. @BrendenCleppe, this might be a dumb question, but HOW did you get your own custom EDF categories, as seen in the screenshot above? Honestly not a hijack, as it looks like I'll be adding this system this afternoon.
  5. I've had luck with this version of the command. It's supposed to pull the source from Windows Update this way. (Note, that agent installation requires .NET 3.5, or you can run into some ugly broken installs.) DISM /Online /Enable-Feature /FeatureName:NetFx3 /All You should be able to run this via "execute script, batch", using SYSTEM - IF the agent isn't broken since it wasn't already installed. I typically just use a batch file stored on a local deployment share, with "run as administrator" self elevation code embedded at the top. You can then either call it as needed (ie; call it from Automate, and as long as the account used is a local admin, script will locally self-elevate,) or create a scheduled task, startup script, etc... No harm done really, if it runs after it's already enabled; it'll attempt, see it's already installed, and exit out. Note, that the same command WITHOUT the /All, works for Win7-8.1, for sourcing online.
  6. If I set my script line to manually: SELECT ComputerId FROM `plugin_vm_hvhosts` WHERE fqdn = 'hostname.domainname.xyz'; But then replace the FQDN with a variable that contains exactly the same FQDN (pulled from powershell command, that pulls it from registry,) the SQL query fails. SELECT ComputerId FROM `plugin_vm_hvhosts` WHERE fqdn = '@VMHostFQDN@'; Note, that the SQL query with written out FQDN works fine in SQLYog as well - so I know the query is OK. I am suspecting maybe something like where the documentation says you must use @= instead of @? It's driving me nuts, because @VMHostFQDN@ = 'hostname.domainname.xyz' !! (This whole thing goes around your elbow ... because I'm trying to capture the VM HOST of a Guest. There will be a monitor that runs on the GUEST, but triggers a script that must run partially on the HOST - powershell commands - to restart said GUEST.) I have captured the Host's name, FQDN and if this gets working, the computerID, into EDF fields - so that it can function as an offline script when the GUEST is offline...
  7. I know this is old, but my question is directly following - and this seems to be a powerful tool, that isn't often discussed. If both scripts being run are set as offline scripts, and the actions being taken are database or Automate server side, would this prevent the script from hanging, if either machine went offline?
  8. I'd swear I saw this in here before, but can't find it. I need to setup an alert, that will run an offline script on the target (ie; when it goes offline,) gather the computerid of this machine, as well as some EDF values (one of which is the computerID of another machine,) and then call a 2nd script to run against the 2nd machine. VMGuest stores Host's name, computerID and FQDN as EDF's. VMGuest goes offline; triggers alert template Template triggers script to collect details needed, then fires script on host, to test connectivity and issue restart vm commands... Can anyone point me back in the right direction for this?
  9. Within your Automate script, use Execute Script, set to Powershell (Powershell Bypass if required,) and then click the square box to the right of the script entry field. This pops up a larger window where you can paste your Powershell code. In THIS area, all normal Automate script variables, can be dropped directly into your Powershell code. It'll expand everything at run time. Works pretty slick.
  10. Thanks, Bobs16! I knew it had to be right in front of me somewhere.
  11. I'm still learning up on my SQL. I need a list of serial numbers for machines that were just taken offline yesterday, and are still in the database. I threw together a script that can pull this via an SQL query, then run the script on the appropriate machines... but it won't run on the ones that are offline, even with unchecking 'skip offline'. I never really thought about it before, but is it possible to run it anyway? The script itself isn't actually doing anything with the agent - just grabbing the %computername% variable, and then using that to pull data from the tables. (I'd rather just export from advanced search, but can't seem to find an option in there for serial numbers?)
  12. I'm working on a concept still, that seems like we should be able to do... unless the new Virtualization Manager is entirely it's own ecosystem? Scenario: VManager HyperV PowerStatus monitor alerts on PowerOff. This monitor captures the %vmname% variable (only to message body?) Alert fires Alert Template, with script setup to use %vmname% as a replacement variable within a Powershell execution, to restart-vm. Is this possible, or is there a better method I haven't thought of yet? The full concept will be a little more complex, with some safety checks, but the gist of it is what I need to work out first.
  13. Sounds like you have an issue with the other script, probably not this here. I'd suggest ignoring that other script for a bit, and make sure you setup the steps in my earlier comment. That at least gives you a way to test whether the bitlocker role detection is working, before you add another layer of complexity (that other script.)
  14. The batch file I put together comes from a combination of what the Sophos in-house engineers use to remove it from their own machines, plus additional discoveries of other registry entries left behind, etc... It also self elevates, as long as you're running it from an admin user (ie; use LT's as {location} admin, and not the default which runs as SYSTEM.)
  • Create New...