Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: last server reboot date and time
Topic Summary: Possible to build a workflow that records reboot time
Created On: 03/02/2018 10:49 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 03/02/2018 10:49 AM
User is offline View Users Profile Print this message

Author Icon
JochenIdeker
Student (5-19 posts)

Posts: 15
Joined: 11/07/2014

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
 03/05/2018 06:10 AM
User is offline View Users Profile Print this message

Author Icon
JochenIdeker
Student (5-19 posts)

Posts: 15
Joined: 11/07/2014

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
 03/05/2018 08:29 AM
User is offline View Users Profile Print this message

Author Icon
Leonard Amabile
HelpSystems

Posts: 5454
Joined: 05/15/2007

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
 03/05/2018 08:32 AM
User is offline View Users Profile Print this message

Author Icon
JochenIdeker
Student (5-19 posts)

Posts: 15
Joined: 11/07/2014

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
 03/09/2018 10:15 AM
User is offline View Users Profile Print this message

Author Icon
Alex Escalante
HelpSystems

Posts: 871
Joined: 02/26/2014

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
 03/09/2018 10:35 AM
User is offline View Users Profile Print this message

Author Icon
Devin Cannon
HelpSystems

Posts: 398
Joined: 03/17/2016

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
Statistics
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 1831 guests browsing this forum, which makes a total of 1831 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog