+ Post New Thread
Results 1 to 1 of 1
MIS Systems Thread, SIMS/Solus3 spreadsheet in Technical; Hi folks, We, at the LA, have about 60 schools on our network which we manage via SOLUS3. Due to ...
  1. #1
    MrMat's Avatar
    Join Date
    Jul 2013
    Thank Post
    Thanked 38 Times in 28 Posts
    Rep Power

    SIMS/Solus3 spreadsheet

    Hi folks,

    We, at the LA, have about 60 schools on our network which we manage via SOLUS3. Due to some of S3's quirks I decided to make a spreadsheet to help manage the upkeep of SIMS and thought it might be worth sharing some of the VB/Batch files with you guys.

    It doesn't do anything amazing and most can be done manually or using other software. Also some of the VB etc is messy!! It was a learning experience for me so I'm sure it could have been made a lot more streamline but I did what i could with my limited knowledge (and Google - lots of Google!).

    Here's how the spreadsheet looks:


    Over here all our machines are badge numbers stuck to the front of the machine. The badge number is an abbreviated version of the computer name. The spreadsheet has a separate worksheet that contains all of the badge numbers and computer names which is where the Combobox gets it's data from.

    Grab the badge number from the user and then hit the required button:

    Add: Allows you to add new machine to spreadsheet via badge number.
    Ping!: Pinched this code off someone else but checks if machine is online and enters result into the status field.
    Details: Displays the machine OS, Microsoft Office version and SIMS version.
    C Drive: Opens up root of machines C drive in explorer
    SIMS.net: Opens up SIMS.net folder in explorer
    PCAnywhere: Opens up PCAnywhere
    RDP: Starts RDP session for machine
    Version: Displays just the SIMS version of machine
    KILL!: Closes Pulsar.exe on machine if currently running
    Start: Starts the S3 Agent service
    Restart: Stops and then starts the S3 Agent service
    Stop: Stops the S3 agent service
    Replace: Deletes the SIMS.net folder and then copies over a source SIMS.net folder from a network share
    Delete: Gives option to either just delete SIMS.net folder or delete SIMS.net folder and SIMS.ini
    Desktop: Figures out if XP or 7 and puts SIMS.net shortcut on desktop
    Replace (p:\SIMS): Replaces the connect.ini on machine to our default
    Uninstall: Uninstalls the S3 agent on machine

    Most of this is done by using VB to create a batch file within the Temp folder of local machine which is then ran, the last line of batch file is always to delete the current batch file once complete so as not to leave Batch files all over the place.

    I'm not going to put up the actual spreadsheet as it contains all our machines and the cell references are a bit of a mess!

    However if you want to know any of the details of either the VB or batch files for any specific process etc, just let me know and i will be happy to post it up.

    Last edited by MrMat; 13th January 2014 at 01:24 PM.

  2. Thanks to MrMat from:

    Rawns (13th January 2014)

+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Data transfer from large excel spreadsheet
    By neil27 in forum MIS Systems
    Replies: 5
    Last Post: 8th January 2013, 12:01 PM
  2. [SIMS] SOLUS3 SIMS Upgrade "Rollback in Progress"
    By Rawns in forum MIS Systems
    Replies: 4
    Last Post: 21st December 2012, 06:44 PM
  3. [SIMS] SIMS Deployment Crossroads - SOLUS3 or RemoteApp
    By mobybrick in forum MIS Systems
    Replies: 25
    Last Post: 13th November 2012, 01:57 PM
  4. [SIMS] Yes or No - Can Solus3 deploy sims to a new workstation?
    By cmaxinuk in forum MIS Systems
    Replies: 11
    Last Post: 22nd December 2011, 02:24 PM
  5. [SIMS] XML spreadsheet from SIMS.net crashing??
    By ljlbray in forum MIS Systems
    Replies: 2
    Last Post: 21st September 2011, 06:46 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts