Skip to content

Instantly share code, notes, and snippets.

@matt40k

matt40k/gist:19199ff41975f792a2b4b963292ddc0f

Forked from anonymous/gist:daa341a45199bb6d6491b576857f4e7d
Last active January 20, 2017 14:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matt40k/19199ff41975f792a2b4b963292ddc0f to your computer and use it in GitHub Desktop.
Save matt40k/19199ff41975f792a2b4b963292ddc0f 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>'
Set-Content -Path param.xml -Value $var
& "c:\program files (x86)\SIMS\SIMS .Net\CommandReporter.exe" /USER:grosg /PASSWORD:ABCD /REPORT:"Behaviour report listing April 08 - Auto" /PARAMFILE:"param.xml" /OUTPUT:"report.csv"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment