Advertisement
Guest User

Untitled

a guest
Jan 20th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. $today = (Get-Date).ToString('yyyy-MM-dd')
  2. $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>'
  3. Set-Content -Path param.xml -Value $var
  4. & "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"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement