Jump to content
Software FX Community

christianv

Members
  • Content Count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About christianv

  • Rank
    Newbie
  1. Yes, if I run the following : invoke-sql -server SACPANICS01 -SQL "set nocount ondeclare @xx table(dataflow varchar(50), FLOW_PROCESS_MIN int,FLOW_DELTA int)insert into @xxSELECT top 26 DATAFLOW, FLOW_PROCESS_MIN, FLOW_DELTA FROM icsadmin.dbo.DataFlowStats (nolock) ORDER BY AuditTimeStamp DESC UPDATE @xx SET FLOW_DELTA = 0 WHERE dataflow IN ('MQMSGMUREX','MQSEQMUREX')SELECT SUM (FLOW_PROCESS_MIN) as Processed,SUM (FLOW_DELTA) as Delta from @xx" | select Processed, Delta I get: Processed Delta --------- ----- 946 946 but I want t
  2. This is what I get, hope this helps us all TypeName: System.Data.DataRowName MemberType Definition---- ---------- ----------AcceptChanges Method System.Void AcceptChanges()BeginEdit Method System.Void BeginEdit()CancelEdit Method System.Void CancelEdit()ClearErrors Method System.Void ClearErrors()Delete Method System.Void Delete()EndEdit Method System.Void EndEdit()Equals Method System.Boolean Equals(Object obj)GetChildRows Method System.Data.DataRow[] GetChildRows(String relationName), System.Data.Dat
  3. It does not show the variable in the get-member it is simply blank (or non-existing). however when I do the following: invoke-sql -server DBserver -SQL "set nocount ondeclare @xx table(dataflow varchar(50), FLOW_PROCESS_MIN int,FLOW_DELTA int)insert into @xxSELECT top 26 DATAFLOW, FLOW_PROCESS_MIN, FLOW_DELTA FROM DBtable.dbo.DataFlowStats (nolock) ORDER BY AuditTimeStamp DESC UPDATE @xx SET FLOW_DELTA = 0 WHERE dataflow IN ('MQMSGMUREX','MQSEQMUREX')SELECT SUM (FLOW_PROCESS_MIN) as Processed,SUM (FLOW_DELTA) as Delta from @xx" | select Processed, Delta I get all variables Kind regard
  4. I am trying to also get the delta displayed, what am I doing wrong?$processed = invoke-sql -server DBSERVER -SQL "set nocount ondeclare @xx table(dataflow varchar(50), FLOW_PROCESS_MIN int,FLOW_DELTA int)insert into @xxSELECT top 26 DATAFLOW, FLOW_PROCESS_MIN, FLOW_DELTA FROM DB.dbo.DataFlowStats (nolock) ORDER BY AuditTimeStamp DESC UPDATE @xx SET FLOW_DELTA = 0 WHERE dataflow IN ('MQMSGMUREX','MQSEQMUREX')SELECT SUM (FLOW_PROCESS_MIN) as Processed, SUM (FLOW_DELTA) as Delta from @xx"$obj = new-object System.objectadd-member -inputobject $obj -membertype NoteProperty -Name Processed -value
  5. Actually I just found out what to do: I ran the following in the PowerShell Window: add-pssnapin PowerGadgets This did the trick. Thanks chrisitan
  6. Thanks Juan, But I am having issues using the (trial version) PowerGadgets with PS as i keep getting: The term 'out-chart' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again. I have reinstalled PS, and PowerGadgets - but still get this am I missing some part of the installation? Kind regards, Christian
  7. Hi I need help getting data to an innergauge, It only seems to hold fixed values, og the same value as the main gauge. thanks :-)
×
×
  • Create New...