|
Easiest way would be to have sql server do it actually- "SELECT COUNT(*) as ItemCount, HostName, DisplayName, EntryDate, Usages GROUP BY HostName" is a step in the right direction.
|
# ¿ May 2, 2011 19:59 |
|
|
# ¿ May 2, 2024 08:21 |
|
No real expert, but the other manning powershell books are first-rate too.
|
# ¿ May 5, 2011 12:48 |
|
First, stop generating XML as strings. It isn't a string it is an object graph with a string representation. As a temporary fix, you should try forcing a particular encoding.
|
# ¿ Mar 6, 2013 13:50 |
|
So they aliased wget in powershell 3. Any idea why it is horribly slow compared to any other http download client? Sub 100mb speeds on a gigabit network with nothing happening slow FWIW.
|
# ¿ Feb 7, 2014 16:22 |
|
One note on finding __UTAH____ -- you can pass a function to a filter -- see http://stackoverflow.com/questions/15536611/how-to-pass-custom-filter-function-to-where-object for an example. So you don't need a 2 stage filter. Personally I would skip the regex here but that is probably because I hate regexes.
|
# ¿ Apr 2, 2014 14:05 |
|
Does their software have the windows accessiblity hooks built in? Is it keyboard operable? Sendkeys is fun and easy and the way we used to do this poo poo before we had newfangled crap like coded ui.
|
# ¿ Jul 29, 2014 15:21 |
|
If you can get the forms to work in a browser then that is easier -- check out http://docs.seleniumhq.org/ for a good tool.
|
# ¿ Jul 29, 2014 16:16 |
|
|
# ¿ May 2, 2024 08:21 |
|
You can chain wheres so if there is a way to say "where name not like conference-room-xxx" or something like that you'd be golden. No idea if there is an effective naming convention you can leverage. Another idea would be to add a piece of metadata to cover "accounts that are disabled but should not be hidden" and then filter on that. Would probably be better than relying upon naming conventions.
|
# ¿ Jul 29, 2014 21:52 |