micheal100 · Principal Solutions Architect · ✭✭✭✭✭

Comments

  • Sorry vanities​, I don't understand the use case I'm afraid. What information do you actually expect to see in the output, especially from the Interfaces table? Can you show examples of the different outputs you're seeing?
    in Network Utilization of Nodes Comment by micheal100 June 2017
  • If you run the modified query in SWQL studio, how many rows are returned?
    in SWQL works in studio but not in Website Comment by micheal100 March 2017
  • I'm not sure why exactly, but the "status" results are causing issues in the custom query resource. I removed lines 2& 3 and it worked ok. But obviously you need those in, I would suggest using a custom table instead, it works better for me (having some issues with the format for the icon, but I think it's workable).
    in SWQL works in studio but not in Website Comment by micheal100 March 2017
  • are you planning on running the script locally on the Orion server, or remotely on the client? If from the Orion server then it will need to be available there.
    in Powershell SQLPS question Comment by micheal100 June 2016
  • Can you explain in a bit more detail what you mean by "when i try to research these computers are update to date?". Is there the original WSUS or a new one? Have there been any changes to products or classifications?
    in Desktop Node Health Overview Comment by micheal100 July 2016
  • Hi doughobbs​, select "Update Services" under Enterprise. Then in the centre pane select the WSUS server you want to delete. Then scroll all the way down to the "delete" option in the right-hand action pane.
    in SPM - remove WSUS server Comment by micheal100 August 2016
  • Hi lauminshen​ have you tried using the "distinct" keyword? SELECT distinct Address, CIDR, FriendlyName as DisplayName, VLAN FROM IPAM.Subnet WHERE CIDR > 0 AND GroupTypeText = 'Subnet';
    in Using custom SWQL to search for subnets Comment by micheal100 March 2017
  • $newDiscovery = New-DiscoveryJob $discName $selectedEngineID $coreParamter Typo in "$coreParamter "
    in Discovery Function Question (PowerShell) Comment by micheal100 September 2017
  • It's purely down to preferences and circumstances really. I'm a PowerShell guy, but that came from years of Windows-only work, and some unique challenges that I found PowerShell much more suited to. You can get PowerShell on Linux now, if needed, (you can also get Bash on Windows). For Orion work I favour PowerShell, again…
    in PowerShell or Python ? Comment by micheal100 February 2017
  • Hi gerthum, what exactly is the use case that you are looking to achieve?
    in Leveraging Powershell DSC in Alert Central Comment by micheal100 June 2016
  • You need to supply a credential get-help Connect-Swis NAME Connect-Swis SYNTAX Connect-Swis [-Credential] <pscredential> [[-Hostname] <string>] [-V2] [<CommonParameters>] Connect-Swis [[-UserName] <string>] [[-Password] <string>] [[-Hostname] <string>] [-V2] [-Soap12 <uri>] [-IgnoreSslErrors] [-TrustX509Thumbprint…
    in SWIS connection problem Comment by micheal100 September 2018
  • I updated the module (Version 0.0.3), to include some new functions, including helper functions (for things such as DNS lookups, which code be used in other scripts). Other changes include changing parameters so they are standard, as well improved error handling. -Whatif functionality added to New-OrionNode &…
    in PowerShell Module based on the SDK Comment by micheal100 March 2014
  • Just looking at the literal URI string you have, the format looks a little off, when I check on mine I get SELECT Uri FROM Orion.Nodes where caption = 'mysql01' swis://Orion11.sales.cork.lab/Orion/Orion.Nodes/NodeID=2 What's the output of $a on both systems? Also, and it should be unrelatd, but just wondering why QoE isn't…
    in Remove-SwisObject : mismatched input 'False' expecting 'Identifier' in Select clause - Is this a bug? Comment by micheal100 March 2017
  • If all the rotated files are stored in the directory you could bypass the txt file and just do something like (and I'm using PowerShell, but you should be able to convert if needed) $files = Get-ChildItem | sort LastWriteTime -Descending | select -first 30 Then just do a simple foreach statement to loop through each file,…
    in Log Parser Pseudocode help Comment by micheal100 November 2015
  • That's a WSUS error, and not Patch Manager specific. I believe some WSUS updates have been known to cause such issues, it's worth checking were any updates applied specifically to WSUS at the weekend.
    in Patch Manager error message - Can't login to SUSDB Comment by micheal100 February 2017
  • The Template reference for Oracle Database covers the credentials required. Credentials: An Oracle user name and password with read access to the Oracle views: dba_free_space, v$sysstat, v$rowcache, v$librarycache, v$sgastat, and v$session.
    in Need advise on SAM to monitor Oracle DB Comment by micheal100 July 2013
  • Have you tried putting it in quotes? 'Major Failure'
    in After upgrade to SAM 6.4 node status names have changed Comment by micheal100 March 2017
  • Troy Hunt has (as normal), an excellent post on the topic. https://www.troyhunt.com/pragmatic-thoughts-on-cloudbleed/
    in Cloudbleed - Welcome to 2017 Comment by micheal100 February 2017
  • Thanks Tim. Just to follow up on that bmcmcm‌ & cnorborg, the PowerShell module I started to work is aimed at doing the standard things most people want, but there will also be the flexibility to use the more powerful SWQL approach as well (in essence that's what the module is, just pre-packaging some standard…
    in Orion WSQL Short-Comings Comment by micheal100 October 2015
Avatar