John, while on the subject of execution ID's and such, during the logging of a psensure, can we add the psensure key to the log so it always outputs what it is checking and validating? How it is now:

INFO : 2018-12-11 20:31:07Z - Configuration drift detected.
DEBUG: 2018-12-11 20:31:07Z - Adding to execution plan.
DEBUG: 2018-12-11 20:31:11Z - Collecting configuration...
DEBUG: 2018-12-11 20:31:11Z - Comparing configuration...
INFO : 2018-12-11 20:31:11Z - Configuration matches template.
DEBUG: 2018-12-11 20:31:14Z - Collecting configuration...
DEBUG: 2018-12-11 20:31:14Z - Comparing configuration...
INFO : 2018-12-11 20:31:14Z - Configuration matches template.

and so on. Maybe it could log something like "Collecting configuration <key>" and "<key> matches template". That way it would make each line meaningful and bring more value into keeping the logs. Eventually I would like to have a way to save a copy of the txt execution into servicenow so we have a record of it in change management system as well. The url you shared previously will help in doing that I think. This improvement would help as documentation for each change. Thanks!

Here is an example I tried doing UNC first, then tried both local paths, and neither worked:

##AH:UseTextMode

Copy-Files
(
Include: **,
From: C:\Temp\Agent\Extensions,
To: C:\Temp2,
Verbose: true,
Overwrite: true
);

So I have noticed that there are 'empty' executions id's that are showing an error. When I use your url provided, after putting in some of the execution id's they show an empty page. If I populate it with another execution ID that has logs, it displays that normally, so I know I am doing it right. Ideas?

John, thank you for that; that is very helpful. Is there a way to look up all of the executions that have happened for a server? I tried replacing the ExecutionID with a serverID, hoping it would list out all of the executions that have occurred for that server, but that didn't work :)

It would be awesome to have a tab on each server that listed out a complete history of all of the executions.

I have several examples; none of them are working. I would like to copy something from a UNC path (NAS Device) to copy to a location on one of the server's in Otter (say the C Drive under C:\Temp for example). Something like a file or a folder structure. Can you share an example of how this works in your environment?

Is anyone else able to shed any insight as to why thins is doing this, or share with me an alternative method to finding these logs? I need to troubleshoot this issue, thanks!

George, thanks for the reply. My point was being this page prevents one from finding out what issues are going on as it displays no relevant information. I am not sure where else I am going to find this information without digging in the SQL database, which I really don't want to do/ have time to do.

Yes, I am on 2.1.1. I usually upgrade within 48 hours of new release and a backup of previous DB.

I am having issues troubleshooting executions of servers in Otter with this screen. It has 3 buttons that don't do anything. Why can't the information just be displayed? The "Set Execution Status" button does not do anything, and the other two buttons "View Log Text" and "Download Full Log" only open up another tab in Chrome to the same screen. This does nothing to assist with troubleshooting. Where or how can I troubleshoot these systems? Thanks!

Product: Otter
Version: 2.1.1

Ticket is submitted along with additional information

Hello, I have been using multiple roles that are gathered to one role that I assign to each server as needed. I have two roles that are assigned to each server, one with about 30 roles and another with 15 roles. I do not want to assign these roles to each server individually. Over time, the performance has been getting worse. I have started performance troubleshooting, and have not found any issues (Checked usual Captain Obvious stuff), so I engaged a member of our SQL Support staff. After running a SQL trace, we saw this being executed that was taking between 3-12 seconds a piece. It is called "exec ServerRoles_GetServerRoles " in SQL Server Profiler. Is there a way to optimize this so it does not use excessive CPU? Thanks!

Product: Otter
Version: 2.1.1

Example it shows for the Execution Dispatcher times for each server. Watching one will show 1:27, 1:28,1:29, and then 2:30. Not a big deal, but a bug nonetheless.

Product: Otter
Version: 2.1.1

I get a "Service cannot be started. System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> " in my event log. I have restarted the machine after trying to restart services, no change yet. SQL is working as other DB's for other apps are working fine. Ideas?

Product: Otter
Version: 2.1.1

I did not have any issues with Otter when switching from a trial to the free version.

So I am trying to figure out the $PSCredential property. I am assuming it's not as simple as just putting a password in plain text for everyone to see? That would be a total no-go. I am assuming that it is pulling the password that is stored from the user specified in "Resource Credentials"?

If not, is there a way to pull those credentials from "Resource Credentials"? I see in each user, there is a "$GetCredentialProperty() function". I tried searching for an example of that without much luck. I Found this https://inedo.com/support/questions/5094 but doesn't shed alot of light except reinforce my belief of a password in plain text. Can anyone provide an example of how that works? Thanks!

Product: Otter
Version: 2.1.0

Hello, I am trying to copy files from a UNC path (I have access to) to a group of servers. I am copying the latest windows security quality monthly rollup patch before we can install the SCCM client. This has to be done per our security policy. I have tried copy file and transfer file, neither seem to do anything. I guess I could do a psensure and do a get-hotfix to see if they are installed and see if I can copy and install from there? I am doing this with Powershell Agentless, and the creditials used are any admin on the server and full control on the nas folder.

Product: Otter
Version: 2.1.0

Alright, after messing around with that information, I was able to get it to work. I am able to update the variables. Interesting thing is that it doesn't appear I can change just one variable, I have to change all of them, or at least enter all of them as they are?

Thanks for your help!

Thanks John. I did try a few variations, and after I ended up renaming a server trying to get your method to work, I decided to stop trying. I am not very familiar with the format you are using, and it is different from the documentation. However, I agree that not adding the key to the URL string is probably a safer way to do it, and that process and examples should be added to the documentation.

I still am not able to update a variable, but if one creates a new server, then you can add variables as long as it's a create. Maybe that will help whoever is going to fix it.

I am not familiar with this way to do it, and it does not appear to work for me:

Invoke-RestMethod : The underlying connection was closed: An unexpected error occurred on a receive.

This appears to be an issue when using headers, but I have not found a reliable way to fix this.

So I am able to update all of the attributes of a server, with the exception of variables. I am able to edit roles, environments, temppath, drift, all without issue. I am not able to change server variables, though. Can anyone test this to confirm it may be a bug, or perhaps I am doing something wrong? Being I can update everything else, I am going to side with the former, but anything's possible.

$Key= 'blahblah'

$Server = 'hdarsintsv1'

$URI = "https://otterserver.test:8626/api/infrastructure/servers/update/$Server`?key=$key"

$Body =

'{

 "variables": 
 
 {
     "Viking": "True",
     
 },

}'

Invoke-RestMethod $URI -Method Post -Body $Body -Verbose