I am curious if it is possible to build a workflow that accomplishes the following.
-records the last reboot time of multiple windows servers.
-gathers the server name, date and time rebooted
-updates a sharepoint spreadsheet with the server name, date and time the server was rebooted.
-runs on a monthly schedule.

I suspect that this is possible. I have a hunch that the AutoMate workflow will use a powershell script hosted on a windows device.

Category Survey

I believe I found a wmi query that can return a boot time of a machine.

<AMWMI RESULTDATASET="ServerRebootDate" NAMESPACE="root\cimv2" HOST="RemoteServer" DOMAIN="domain" USERNAME="UserName" PASSWORD="password">SELECT *
FROM Win32_OperatingSystem
</AMWMI>

Category Survey

Hi Jochen,

Was this step able to get you the information you need?

Category Survey

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Yes. I think it will pull the data I am looking for. Is it possible for Automate BPA Server (10.7) to edit excel spreadsheets in Sharepoint?

Category Survey

Hello Jochen,

You will need to download the spreadsheet, edit, then re-upload. We cannot write directly into Sharepoint using the current sharepoint actions.

Category Survey

-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

I was able to get a SharePoint library mapped as a network location in Windows Explorer and then use Excel/OpenDocument actions pointed to the network location to modify Excel files.
I used this guide to setup the share:
https://blog.kloud.com.au/2013/09/06/map-sharepoint-libraries-with-local-file-drive-a-step-by-step-guide/

Category Survey

-------------------------

Devin Cannon | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665