Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
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
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 343 guests browsing this forum, which makes a total of 343 users using this forum.

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

Sitemap Network Automation Software Blog