Tag: Scripts

  • Make New ActiveBatch Job References Using PowerShell

    caleb

    ActiveBatch is a workload automation solution that is extremely powerful when utilized properly. It’s intuitive to work in and can be very powerful with well-defined processes. ActiveBatch has one or more “job schedulers” that schedule and queue jobs, and connect to a database to store job properties, including schedules, variables, steps, etc. An “execution agent”… Read more

  • Using Excel COM Object to Auto-Edit Antiquated Spreadsheets

    caleb

    I’ve recently been configuring reporting to work with a new software in the cloud. As with much enterprise software, developers spend more time maintaining the code and slurping money than they do modernizing. Specifically, the reporting tool’s connections were all broken, and the only option was to save documents as Excel 1997 documents. The document… Read more

  • ARM Template to Easily Create an Azure WordPress Website

    caleb

    Microsoft’s documentation has a link to a QuickStart template that does this, but it doesn’t follow naming conventions for some reason. Here’s an ARM template to fix that. Resources Created: You will still have to retool these JSON files, I’ve noted the properties that you will need to specify like <this>. There are other values… Read more

  • GUID Filename Renaming for Easy Identification Using PowerShell

    caleb

    A GUID (Globally Unique ID) is a random set of characters sometimes used as a filename. This script has a use case that is not uncommon. GUID Rename Use Case I have alchemy reports sorted by active ingredient in my “C:\Users\Wiz\Alchemy” folder, in this case Mercury. Inside, I have many subfolders. The subfolder “apprentices_maimed” holds… Read more