Skip to content

Instantly share code, notes, and snippets.

/gist:daa341a45199bb6d6491b576857f4e7d

Created January 20, 2017 14:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save anonymous/daa341a45199bb6d6491b576857f4e7d to your computer and use it in GitHub Desktop.
Save anonymous/daa341a45199bb6d6491b576857f4e7d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
$today = (Get-Date).ToString('yyyy-MM-dd')
$var = '<ReportParameters><Parameter id=\"1ikmaygI4+fhpdNyAeUC2A==\" subreportfilter=\"True\"><Name>Status</Name><Type>List</Type><PromptText>Status </PromptText><Values><ValidValue><Id>NULL</Id><Code>1</Code><Description>NULL</Description></ValidValue><ValidValue><Id>Further Intervention Required</Id><Code>1</Code><Description>Further Intervention Required</Description></ValidValue><ValidValue><Id>Resolved</Id><Code>1</Code><Description>Resolved</Description></ValidValue><ValidValue><Id>Resolved(1)</Id><Code>1</Code><Description>Resolved(1)</Description></ValidValue><ValidValue><Id>Unresolved</Id><Code>1</Code><Description>Unresolved</Description></ValidValue><ValidValue><Id>Unresolved(1)</Id><Code>1</Code><Description>Unresolved(1)</Description></ValidValue></Values></Parameter><Parameter id=\"mnz1mh+M9RnxwnGABFIBTg==\" subreportfilter=\"True\"><Name>Date</Name><Type>DateRange</Type><PromptText>Date is between</PromptText><Values><DateRange><Start>' + $today + 'T00:00:00</Start><End>' + $today + 'T23:59:59</End></DateRange></Values></Parameter></ReportParameters>'
$params = '/PARAMS:' + $var
& "c:\program files (x86)\SIMS\SIMS .Net\CommandReporter.exe" "/USER:" "/PASSWORD:" "/REPORT:Behaviour report listing April 08 - Auto" $params '/OUTPUT:"report.csv"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment