The most recent content from our members.
They work in some specific ways in the select statement, and in the from statement at least, and seem to be close-to-required for modern dashboards. If you're asking a DBA for the way they'd write the SQL to solve a problem, the WITH they'd normaly use doesn't work, and it looks as if there's no option for this, which…
Enhance SWQL statements to allow reuse of aliases in the preceding SELECTION. Examples: SELECT A , A * B AS AB , B , B / A AS BA , AB + BA AS ABBA FROM TABLE; SELECT N.IPAddress AS IP , N.DnsBackward NAME , CHARINDEX('.',IP,1)-1 AS P1 , CHARINDEX('.',IP,P1)-1 AS P2 , CHARINDEX('.',IP,P2)-1 AS P3 , CHARINDEX('.',IP,P3)-1 AS…
I'm trying to parse strings and am trying to refer to an alias in the SWQL query. In the following query, I can refer to the alias IP without issue. However, the alias from the CHARINDEX expression gives an exception: Cannot resolve property P1. SELECT N.IPAddress AS IP , N.DnsBackward , CHARINDEX('.',IP,1)-1 AS P1 ,…
An incoming mail account should be able to specify additional aliases that correspond to the mailbox. In essence, the challenge we're running into stems from the fact that our mailbox for WHD receives mail via 2 email addresses. The first is heldesk@mysite.com which is for regular email from users. The second is…
Whenever I connect to a new Host, I put in a unique Alias and click the Save button. At least half the time, the next time I open DameWare MRC it has the Host name duplicated into the Alias field, and the Alias that I entered is gone. I'm using DameWare MRC v10.0.0.372 64-bit
Is there a maximum number of characters that will be displayed in the Interface Caption or Interface Alias field? It seems like the most I can get to display is 65 characters, even though I have interface descriptions on the switch well over 65 characters. I tested this by making an interface description that was the max…
It looks like you're new here. Sign in or register to get started.