PowerShell Requirements
Hi All,
Need some assistance here. I found a PowerShell script online to start off as a template but having a bit of trouble trying to accomplish what I want. My requirements are:
1. Leverage a CSV file to store hostnames.
2. Using the CSV file, test connectivity using ping.
2a. If ping fails, output this to the console stating which server the ping failed and move on to the next hostname.
2b. If ping succeeds, output this to the console stating which server the ping succeeded and move on the next requirement.
3. Determine if a specific service is stopped or started using wildcards for example *DocAve*.
3a. If the service is already started, report this via output and move on to the next one.
3b. If the service is stopped, report this via output and start the service.
This is what I have so far:
$hosts = Import-Csv docave_hosts.csv
foreach ($host in $hosts)
{
$hostname = $host.name
$IP = (Test-Connection $hostname -Count 1 -ErrorAction SilentlyContinue | Select-Object -expandproperty protocoladdress)
if ($IP -eq $null) {continue}
{
$servicestate = Get-Service -ComputerName $Hostname "*DocAve*" -ErrorAction SilentlyContinue
}
if ($servicestate.status -ne 'Stopped' -or $servicestate.status -eq $null) {continue}
{
(Get-Service -ComputerName $Hostname "*DocAve*").Start()
Set-Service -ComputerName $Hostname -Name "*DocAve*" -StartupType Automatic
Write-Host "Starting services..." -BackgroundColor white
Get-Service -ComputerName $Hostname "*DocAve*"
}
}
Would anyone be able to clean it up for me or make adjustments as needed? Sorry, I'm not a PowerShell expert.
- Changed type Bill_Stewart Monday, October 31, 2016 6:38 PM
- Moved by Bill_Stewart Monday, October 31, 2016 6:38 PM This is not "scripts on demand"
Reply:
No. because we do not rewrite scripts on demand.
I will point out one thing that is not correct:
This:
$IP = (Test-Connection $hostname -Count 1 -ErrorAction SilentlyContinue | Select-Object -expandproperty protocoladdress)
if ($IP -eq $null) {continue}
{
$servicestate = Get-Service -ComputerName $Hostname "*DocAve*" -ErrorAction SilentlyContinue
}
Should be this:
if(Test-Connection $hostname -Count 1 -Quiet){ $services = Get-Service -Name *DocAve* -ComputerName $Hostname }else{ Write-Host "$hostname not found" } You also need to understand that the services returned can be more than one so you will have to enumerate them. To avoid this use a specific service name.
Get-Service -Name MyDocService -Computer ...
Place all code that works when the computer is found in the top part of the "if" statement.
I recommend that you spend some time here: https://technet.microsoft.com/en-us/dd742419
\_(ツ)_/
------------------------------------
Reply:
Please read the following first - it is right at the top of this forum.
This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
SharePoint 2013 July 2014 CU - People Picker fields empty in Edit forms
After applying the July 2014 CU for SharePoint server, I discovered that Person or Group (People Picker) fields are not populated with server values in list item Edit forms. However, the field values can be viewed in list views and in Display forms. I examined the client side code and determined that field data is not being returned from the server for Edit forms.
In a test environment, I uninstalled SharePoint 2013, reinstalled SP 2013 with SP1 and the issue went away. I then applied the May 2014, June 2014, and July 2014 CUs. The issue did not exist after applying the May and June CUs. It did exist after applying the July 2014 CU.
- Changed type J Haugen Wednesday, August 13, 2014 4:10 PM
Reply:
Hi ,
For this issue, I'm trying to involve someone familiar with this topic to further look at it.
Thanks,
Eric
Eric Tao
TechNet Community Support
------------------------------------
Reply:
did you try to install the new released August 2014 CU for SharePoint 2013?
Does the problem still exists with the new CU?
Thanks,
Bernd
------------------------------------
Reply:
Hi ,
For this issue, I'm trying to involve someone familiar with this topic to further look at it.
Thanks,
Eric
Eric Tao
TechNet Community Support
Any News on this? Because we have the same Problem and Need to solve this as soon as possible.
Regards, Simon
------------------------------------
Reply:
------------------------------------
Reply:
I found out the following:
If you give the user the permission for:
List Permissions: Manage Lists - Create and delete lists, add or remove columns in a list, and add or remove public views of a list.
Then the Information from the People Picker will be avaible and resolved again...
But this is not a solution for us, just a work-around.
Regards, Simon
------------------------------------
Reply:
Hi Simon,
Thank you for your patience.
After you grant the permission, the people picker works well now. I will try to reproduce this issue in my lab. And I would your help to upgrade to the latest SharePoint CU and check if issue persists.
Thanks,
Dats Luo
------------------------------------
Reply:
Hi,
have exactly the same problem on Sharepoint Foundation 2013 CU July 2014 , have you a solution?
thx
Marco
same Problem... by CU August 2014
EditForm.aspx
- Edited by FrMarco Monday, August 25, 2014 6:32 PM Reason
------------------------------------
Reply:
Hi,
as a workaround, you can perform the following steps to circumvent the issue:
1. On an affected list, select a list item an click Edit Item
2. Click on the Settings menu designated with a gear icon
3. Select the Edit page menu option
4. Click on the dropdown menu next to the title of the list, and expand the miscellaneous heading.
5. Update the CSR Render Mode to ServerRender
6. Click Apply, and then click OK
7. Click on the Stop Editing button in the ribbon.
That workaround needs to be used for ervery single list any user is creating.
For this problem Microsoft has already a hotfix that will be published with the CU September 2014.
------------------------------------
Reply:
Hi,
is there the possibility to get this hotfix right now? Or will it only be part of the CU Sep 2014?
When will the CU be published?
Thanks and Regards!
------------------------------------
Reply:
http://blogs.technet.com/b/stefan_gossner/archive/2014/09/10/september-2014-cu-for-sharepoint-2013-has-been-released.aspx
------------------------------------
Reply:
I have applied the September 2014 CU for SharePoint Foundations 2013 and I can confirm in both my dev and qa farms that this issue is not fixed after trying with the latest CU.
Can someone else out there verify what they see?
Thanks,
BJ
------------------------------------
Reply:
There is a workaround for this issue. It's a little convoluted, but hey, it's SharePoint. First, you must have a list that has at least one entry in it.
- To begin with, you must first have a list with at least one item in the list.
| | |
| · Next you edit the item with a role that has at least Design privilege, but don't save your changes. |
|
| · Instead you Edit the page so you can then edit that web part. You can edit the page by clicking on the cog icon and selecting Edit Page |
- Edit the web part itself
- Under "Miscellaneous" section on the just exposed web part window, select "Server Render (Server Render)" in the drop down labeled "CSR Render Mode
- Click on "Apply" button within the web part
- Save
I was told also the Sept CU would fix the issue but it is under review and to wait until the first of October. Incidentally we found that if you put the entire list into Quick Edit mode, the issue does not appear.
I hope this helps someone.
- Edited by jmwills Friday, September 19, 2014 1:58 PM
------------------------------------
Reply:
------------------------------------
Reply:
I can confirm with jmwills that this workaround is the temporary solution. I was on the phone with MS support earlier this week and they suggested the same steps for me to correct my forms and they work now after I make the correction to "Server Render"
Thanks!
BJ
------------------------------------
Reply:
Hi Simon,
Thank you for your patience.
After you grant the permission, the people picker works well now. I will try to reproduce this issue in my lab. And I would your help to upgrade to the latest SharePoint CU and check if issue persists.
Thanks,
Dats Luo
Hi Dats,
Any update when there will be a hotfix available? August Security update KB2880994 also causing this issue.
http://sharepoint.stackexchange.com/questions/112332/sharepoint-task-list-security-patch-error
Thanks!
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
Did you installed Sept-cu latest and see whether the issue still exists?
http://expertsharepoint.blogspot.de/2014/09/september-2014-cu-for-sharepoint-2013.html
Anil Avula[MCP,MCSE,MCSA,MCTS,MCITP,MCSM] See Me At: http://expertsharepoint.blogspot.de/
------------------------------------
Reply:
Hi Anil,
Not sure whether you checked the other posts where people already indicated Sept CU does not fix this issue.
Microsoft lately really messing up with every other patches/CU/SP in 2013. Focus shifted elsewhere :-)??
Thanks anyway!
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
Hi,
does anybody know a solution for this bug? The workaround is working but it's a little creepy to go through hundreds of lists with People Picker fields ...
Thanks a lot!
------------------------------------
Reply:
The Hotfix , i.e. the Sept CU does not fix it.
Hi JMWills/ BJ fentress,
I'm confused now...reading the KB2889884 - it specifically says it is THE fix (see below). What is your Configuration DB version after you applied the Sept CU?
"
- Consider the following scenario:
- You create a SharePoint 2013 list that contains a Person or Group (people picker) column.
- You create or edit an item, and then you select a person whose name contains a comma in the Person or Group field.
"
Thanks!
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
Hi Blue,
My config DB's version is below:
15.0.4641.1000
Once I applied this it did not fix it for me. I have both a SharePoint Server and a SharePoint foundation farm and it didn't fix it for me on either farm, so I have had to use the workaround mentioned by BerndV_WAG above.
I have not been able to test the October CU out yet, but I am hopeful it helps the situation.
Thanks,
BJ
- Edited by bj fentress Wednesday, October 22, 2014 5:48 PM correction
------------------------------------
Reply:
@BJ, does your manage server page in central admin show for status 'no action required'? I wonder if your Sept CU update got installed correctly? As I see KB2760319 show the same DLL version as your config DB is. it's supposed to get to 15.0.4649.1001 with Sept CU.
Hope this helps!
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
Well I have updated one of my Dev farms now to the October 2014 CU for this issue and it doesn't seem to work as well with the October 2014 CU applied on SharePoint Foundations.
I guess I'm back to changing every list to render individually from the server.
I wish they would actually fix this issue instead of getting my hopes up each month and then getting disappointed.
Thanks,
BJ
------------------------------------
Reply:
Trevor Seward
Follow or contact me at...
This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
------------------------------------
Reply:
Can you confirm that it works from a 2010 farm that was upgraded to 2013 and then patched to September CU? That is the scenario I am facing.
All of the newly created items I have existing from my conversion are the ones that don't work. If I create new items in the 2013 environment they are fine. It's only the older items I am having this issue with.
Thanks,
BJ
------------------------------------
Reply:
Trevor Seward
Follow or contact me at... This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
------------------------------------
Reply:
Yes, my content DB's were at build 14.0.7125.5000 before we converted to 2013 and then onto the Sept and October 2014 CU's in SharePoint 2013.
I'm not sure if this problem only exists with users whose display names have commas, but it happens to us when we go to the existing older items and try to open them in the normal edit form. When we do this, the eisting username that was assigned to the item simply disappears.
Since this happens on older items our issue will gradually go away with time, but it's just hard having to manually correct this on each list for the time being.
Thanks,
BJ
------------------------------------
Reply:
We do have the same issue. The September CU didn't solve the problem. I can confirm that our users also have a comma in the display name (lastname, firstname) and the SiteCollection was converted from 2010.
As a temporary Workaround we've changed the permission Level (add "Manage lists" rights).
------------------------------------
Reply:
Hi Lars,
Can you please explain how your workaround works? Did you not have this issue with your 'Full Control' users - where 'Manage Lists' permission already part of?
Just curious. As what we're seeing appears not related to the user permission level.
Thank you!
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
I can confirm that this is resolved in the September 2014 CU.Thanks Trevor for confirming this!
Trevor Seward
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
------------------------------------
Reply:
Hi,
I do have the same problem. Users with "Contribute"-rights only do not see the entries in people picker fields.
Then I followed the advices above and changed the CSR Render Mode to "Server Render". This solution works perfect for this issue, but a new problem occurs.
When the Render Mode is Server, the people picker fields doesn't show any suggestions when I type a name. This means I have to type in the name absolutly correct (Surname, Firstname) and then eventually the name is accepted.
Is there any solution for both problems?
------------------------------------
Reply:
Hi Drossmann,
Did you apply Sept 2014 CU - see above posts; people has confirmed this fixes the issue.
Thanks,
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
Has anyone been able to confirm if October or November CU addresses the reported issue for sites that have been migrated from a previous version of SharePoint?
From this thread - it seems the issue was resolved in the September 2014 CU for site collections built in SP2013, but not for those migrated from previous SharePoint versions.
------------------------------------
Reply:
BlueSky2010
Please help and appreciate others by using forum features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"
------------------------------------
Reply:
Update 2016: None of the "fixes" reported here actually worked for us my company. What did work was to change the "Show type" for the field to different type (user, Name, Name with Precense), etc. and then suddenly it will start working correctly. Cannot explain this behavior.After applying the July 2014 CU for SharePoint server, I discovered that Person or Group (People Picker) fields are not populated with server values in list item Edit forms. However, the field values can be viewed in list views and in Display forms. I examined the client side code and determined that field data is not being returned from the server for Edit forms.
In a test environment, I uninstalled SharePoint 2013, reinstalled SP 2013 with SP1 and the issue went away. I then applied the May 2014, June 2014, and July 2014 CUs. The issue did not exist after applying the May and June CUs. It did exist after applying the July 2014 CU.
------------------------------------
Announcing Windows 10 Insider Preview Build 14936 for PC and Mobile
- Changed type ZigZag3143x Wednesday, September 28, 2016 6:33 PM No question
Headless installation, autounattend.xml
Continued discussion from another thread...
The idea of this thread is to share how to install Windows Server 2012 (Beta) Essentials on a server without display/keyboard. On my part, I installed it on my old WHS server, which is an enhanced (new CPU, more memory) HP MediaSmart server EX 490.
What I did was this:
- Prepare the USB stick (I used the"Windows 7 USB DVD Download Tool"); Also copy autounattend.xml to the USB stick; Plug-in the stick at the back of my server (front USB ports don't boot).
- Remove all disks from the server.
- Clean the disk intended as the system disk (I did this in my desktop PC, with DISKPART).
- Install the cleaned disk in the bottom bay.
- Turn on the machine, and wait for a long time (it took almost an hour, much longer than an installation on a virtual machine).
- Browse to the server (http://server/connect)
- Enter data (product key etc.), and wait some more
- Once set-up, proceed with connecting the clients
The autounattend.xml was produced with Windows System Image Manager (aka WSIM).
Here is the autounattend.xml, which works on the system described above:
<?xml version="1.0" encoding="utf-8"?> <unattend xmlns="urn:schemas-microsoft-com:unattend"> <settings pass="windowsPE"> <component name="Microsoft-Windows-International-Core-WinPE" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <SetupUILanguage> <UILanguage>en-US</UILanguage> </SetupUILanguage> <InputLocale>de-CH</InputLocale> <SystemLocale>de-CH</SystemLocale> <UILanguage>en-US</UILanguage> <UserLocale>de-CH</UserLocale> <UILanguageFallback></UILanguageFallback> </component> <component name="Microsoft-Windows-Setup" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <DiskConfiguration> <Disk wcm:action="add"> <CreatePartitions> <CreatePartition wcm:action="add"> <Order>1</Order> <Size>350</Size> <Type>Primary</Type> </CreatePartition> <CreatePartition wcm:action="add"> <Extend>false</Extend> <Order>2</Order> <Type>Primary</Type> <Size>122880</Size> </CreatePartition> </CreatePartitions> <ModifyPartitions> <ModifyPartition wcm:action="add"> <Active>true</Active> <Format>NTFS</Format> <Label>Boot</Label> <Order>1</Order> <PartitionID>1</PartitionID> </ModifyPartition> <ModifyPartition wcm:action="add"> <Format>NTFS</Format> <Label>System</Label> <Order>2</Order> <PartitionID>2</PartitionID> </ModifyPartition> </ModifyPartitions> <DiskID>0</DiskID> <WillWipeDisk>true</WillWipeDisk> </Disk> </DiskConfiguration> <ImageInstall> <OSImage> <InstallFrom> <MetaData wcm:action="add"> <Key>/IMAGE/NAME</Key> <Value>Windows Server 2012 Essentials</Value> </MetaData> </InstallFrom> <InstallTo> <DiskID>0</DiskID> <PartitionID>2</PartitionID> </InstallTo> <InstallToAvailablePartition>false</InstallToAvailablePartition> <WillShowUI>OnError</WillShowUI> </OSImage> </ImageInstall> <UserData> <ProductKey> <WillShowUI>OnError</WillShowUI> <Key></Key> </ProductKey> <AcceptEula>true</AcceptEula> <FullName>[Your Name]</FullName> <Organization>[Your Org]</Organization> </UserData> </component> </settings> <settings pass="specialize"> <component name="Microsoft-Windows-Shell-Setup" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <ComputerName>Everest</ComputerName> <RegisteredOrganization>[Your Org]</RegisteredOrganization> <RegisteredOwner>[Your Name]</RegisteredOwner> <TimeZone>W. Europe Standard Time</TimeZone> <ProductKey>XXXXX-XXXXX-XXXXX-XXXXX-XXXXX</ProductKey> </component> <component name="Microsoft-Windows-TerminalServices-LocalSessionManager" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <fDenyTSConnections>false</fDenyTSConnections> </component> <component name="Networking-MPSSVC-Svc" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <FirewallGroups> <FirewallGroup wcm:action="add" wcm:keyValue="Remote Desktop"> <Active>true</Active> <Group>@FirewallAPI.dll,-28752</Group> <Profile>all</Profile> </FirewallGroup> </FirewallGroups> </component> </settings> <cpi:offlineImage cpi:source="wim:d:/temp/install/install.wim#Windows Server 2012 Essentials" xmlns:cpi="urn:schemas-microsoft-com:cpi" /> </unattend>
Reply:
Grey
------------------------------------
Reply:
------------------------------------
Reply:
Adding this link back from your first post for the time zone
http://technet.microsoft.com/en-us/library/ff715394.aspx
So the "new" cfg.ini file will only do the WSE12 OOBE (Out Of Box Expereince), therefore it is no good for headless. Combine a cfg.ini with the above autounattent.xml for a complete headless install. put both files in the root of the install media.
cfg.ini sample
[InitialConfiguration]
;Optional, display language can only be one of the installed language
Language=en-us
;Optional, The name of a script that runs after setupComplete.cmd but before the initial configuration begins.
;Optional
Locale=en-us
;Optional
Country=US
;Optional
Keyboard=0409:00000409
AcceptEula=true
;This is only required on a server where an OEM EULA has been specified
;by using the OOBE.xml file
;Optional. Example: My Company Name
CompanyName=Contoso
ServerName=MyServer
; Example: CONTOSO
NetbiosName=contoso
; Example: contoso.local
DNSName=consoto.local
; Used to set the user name for the domain admin
UserName=Grey
;The password has to be strong and at least 8 characters
PlainTextPassword=Passw0rd
;. Used to set the user name for the domain standard user account. Ignored in migration mode.
StdUserName=Grace
;. The password for the domain standard user account has to be strong and at least 8 characters
StdUserPlainTextPassword=Passw0rd
;Controls the Watson and automatic update settings
Settings=None
Grey
------------------------------------
Reply:
Unattend innstall with .xml file will not work on my EX470. I have followed all instruktions but the installation stops each time after preparing/configuring the disk. No install files copyed/installed. Also tryed with the cfg.ini file too. Have no VGA-cable yet. Any idea how to proceed? Struggeled with these for many days now...Continued discussion from another thread...
The idea of this thread is to share how to install Windows Server 2012 (Beta) Essentials on a server without display/keyboard. On my part, I installed it on my old WHS server, which is an enhanced (new CPU, more memory) HP MediaSmart server EX 490.
What I did was this:
- Prepare the USB stick (I used the"Windows 7 USB DVD Download Tool"); Also copy autounattend.xml to the USB stick; Plug-in the stick at the back of my server (front USB ports don't boot).
- Remove all disks from the server.
- Clean the disk intended as the system disk (I did this in my desktop PC, with DISKPART).
- Install the cleaned disk in the bottom bay.
- Turn on the machine, and wait for a long time (it took almost an hour, much longer than an installation on a virtual machine).
- Browse to the server (http://server/connect)
- Enter data (product key etc.), and wait some more
- Once set-up, proceed with connecting the clients
The autounattend.xml was produced with Windows System Image Manager (aka WSIM).
Here is the autounattend.xml, which works on the system described above:
------------------------------------
Reply:
It is proven to work, my guess is your unatend is bad, and or a bad disc
Grey
- Edited by Still Grey Monday, October 8, 2012 11:52 PM
------------------------------------
Reply:
Is your Ex470 upgraded? WSE2012 requires 2 GB RAM minimum and the stock EX470 came with 512 MB RAM.
When I installed WHS2011 on my EX470, I did it by removing the boot drive and installing it in a PC (this is described in http://www.kewney.com/posts/database/installing-windows-home-server-2011-on-hp-mediasmart-ex470-or-ex475). I didn't try this for WSE as I am using new hardware, but the same approach might work.
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
In many cases this process is not necessary. I started the installation on another PC (maybe a PC that is not too modern) with 64bit processor, keyboard and monitor. When I asked the first installation reboot the PC turned off, remove the hard drive and insert it into my EX490. The installation continued and after a while it detected on the network with a ping to the name he had given to the server. From that moment I logged on Terminal Server and continue with the installation.
Hardware Astracción Layer in newer versions of Windows is much improved and allows these things.
- Edited by amgl7223 Friday, February 1, 2013 11:27 AM
------------------------------------
Reply:
Hello Tinue,
What processor and memory do you have?
I want a upgrade to
------------------------------------
Reply:
<unattend xmlns="urn:schemas-microsoft-com:unattend">
<settings pass="windowsPE">
<component name="Microsoft-Windows-International-Core-WinPE" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SetupUILanguage>
<UILanguage>en-US</UILanguage>
</SetupUILanguage>
<InputLocale>de-CH</InputLocale>
<SystemLocale>de-CH</SystemLocale>
<UILanguage>en-US</UILanguage>
<UserLocale>de-CH</UserLocale>
<UILanguageFallback></UILanguageFallback>
</component>
<component name="Microsoft-Windows-Setup" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<DiskConfiguration>
<Disk wcm:action="add">
<CreatePartitions>
<CreatePartition wcm:action="add">
<Order>1</Order>
<Size>350</Size>
<Type>Primary</Type>
</CreatePartition>
<CreatePartition wcm:action="add">
<Extend>false</Extend>
<Order>2</Order>
<Type>Primary</Type>
<Size>122880</Size>
</CreatePartition>
</CreatePartitions>
<ModifyPartitions>
<ModifyPartition wcm:action="add">
<Active>true</Active>
<Format>NTFS</Format>
<Label>Boot</Label>
<Order>1</Order>
<PartitionID>1</PartitionID>
</ModifyPartition>
<ModifyPartition wcm:action="add">
<Format>NTFS</Format>
<Label>System</Label>
<Order>2</Order>
<PartitionID>2</PartitionID>
</ModifyPartition>
</ModifyPartitions>
<DiskID>0</DiskID>
<WillWipeDisk>true</WillWipeDisk>
</Disk>
</DiskConfiguration>
<ImageInstall>
<OSImage>
<InstallFrom>
<MetaData wcm:action="add">
what do I put here <Key>/IMAGE/NAME</Key>
<Value>Windows Server 2012 Essentials</Value>
</MetaData>
</InstallFrom>
<InstallTo>
<DiskID>0</DiskID>
<PartitionID>2</PartitionID>
</InstallTo>
<InstallToAvailablePartition>false</InstallToAvailablePartition>
<WillShowUI>OnError</WillShowUI>
</OSImage>
</ImageInstall>
<UserData>
<ProductKey>
<WillShowUI>OnError</WillShowUI>
<Key></Key>
</ProductKey>
<AcceptEula>true</AcceptEula>
<FullName>[Your Name]</FullName>
<Organization>[Your Org]</Organization>
</UserData>
</component>
</settings>
<settings pass="specialize">
<component name="Microsoft-Windows-Shell-Setup" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ComputerName>Everest</ComputerName>
<RegisteredOrganization>[Your Org]</RegisteredOrganization>
<RegisteredOwner>[Your Name]</RegisteredOwner>
<TimeZone>W. Europe Standard Time</TimeZone>
<ProductKey>XXXXX-XXXXX-XXXXX-XXXXX-XXXXX</ProductKey>
</component>
<component name="Microsoft-Windows-TerminalServices-LocalSessionManager" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<fDenyTSConnections>false</fDenyTSConnections>
</component>
<component name="Networking-MPSSVC-Svc" processorArchitecture="amd64" publicKeyToken="31bf3856ad364e35" language="neutral" versionScope="nonSxS" xmlns:wcm="http://schemas.microsoft.com/WMIConfig/2002/State" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<FirewallGroups>
<FirewallGroup wcm:action="add" wcm:keyValue="Remote Desktop">
<Active>true</Active>
<Group>@FirewallAPI.dll,-28752</Group>
<Profile>all</Profile>
</FirewallGroup>
</FirewallGroups>
</component>
</settings>
<cpi:offlineImage cpi:source="wim:d:/temp/install/install.wim#Windows Server 2012 Essentials" xmlns:cpi="urn:schemas-microsoft-com:cpi" />
</unattend>
------------------------------------
Reply:
On first glance, this seems to be for 64-bit processor architectures, hence the "amd64" reference. There's also other very specific values in the example which may not work in each and every case.
With other words: do not consider this example "universal" because it is not.
------------------------------------
Reply:
Grey
------------------------------------
Reply:
- Edited by duraley Wednesday, September 28, 2016 4:54 PM
------------------------------------
Reply:
He meant he RDP (MSTSC) to the name he gave server during setup. The User would be administrator and the password would be the one entered during setup
What is MSS? a Headless box?
Grey
------------------------------------
Find TeamViewer IDS accross the domain
is there a script to get all teamviewer ids accross the domain ?
- Changed type Bill_Stewart Monday, October 31, 2016 6:24 PM
- Moved by Bill_Stewart Monday, October 31, 2016 6:24 PM This is not third-party software support forum
Reply:
Teamviewer? Are you asking a quesiton about "Team Foundation Server"?
For pre-written scripts see: https://gallery.technet.microsoft.com/
\_(ツ)_/
------------------------------------
Reply:
- Edited by Vincent Karunaidas Wednesday, September 28, 2016 8:38 AM
------------------------------------
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
Automatic ticket creation in CA service desk manager tool through powershell
Hello,
I am working on a powershell project which requires me to automate creation of a incident ticket in CA service desk manager tool. Could someone please confirm if this is possible? if so, Could you please also provide some idea on how to go about it.
Thanks, JK
- Changed type Bill_Stewart Monday, October 31, 2016 6:23 PM
- Moved by Bill_Stewart Monday, October 31, 2016 6:24 PM This is not third-party component/module support forum
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
How to make a script to run command by command
Hi
How can I make my script commands to run one by one , when i run my batch , it runs all the commands at the same time , but i need them to be executed one line at a time
please help
- Changed type Bill_Stewart Monday, October 31, 2016 6:23 PM
- Moved by Bill_Stewart Monday, October 31, 2016 6:23 PM Unanswerable drive-by question
Reply:
\_(ツ)_/
------------------------------------
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
Is Windows 10 Anniversary update available in partial block downloads?
My computer has been trying to update with the Windows 10 Anniversary update since it has been released.
It is unable to download and install the 4.1 GB update properly. The download is taking over 12 hours and is restarted each time I shut down the laptop before it is completed.
On the one occasion it was downloaded, there was an update failure and the whole process was restarted.
Is this update available in a block form - smaller download blocks, which windows update can reconstruct?
Or is software available to manage this update download without having to restart if i shutdown before completion?
Also, is there a way to manually download the update and store locally in case updating fails?
Computer specs:
Laptop, Toshiba Satellite P50t-A, 8GB Ram, Intel i7 processor, Windows 10 Home.
Reply:
S.Sengupta, Windows Insider MVP
------------------------------------
**FIX** Winload.exe Is Missing Or Corrupt (No Its Not)
So we have all seen and heard the many solutions to this issue, most which refer to the direct editing of the BCD and MBR..
However, no one has pointed out exactly why this issue happens, which should be the first step in identifying a fix. The corruption of BCD occurs, In the most part, when the vista setup finishes and the sysprep command is run, generalising BCD, and in most cases i have found, users running either a dual boot, or seperate HD's, the generalisation of BCD fails. It can also occur after installing the update KB936330, also known as Vista service pack 1.
I am unsure why the issue can occur after installing the service pack, but I am certain that a generalised BCD was included in the package (Generalised being an OOBE prepared BCD.exe) and this may pertain to why some systems have this issue after, as additional HD's may not be installed until after the initial setup. We can be certain that no system with one HD is suffering from this issue, and that the problem extends from the shutdown sequence.
There are two fixes, One pertaining to a single boot system, and one pertaining to a multi-boot system. Usually the system will be afflicted with either, but in some cases, can be afflicted by both.
THE PROCESS
Once running a repair from the Vista disc, windows should boot fine once, but upon a shutdown the same error will be presented. However upon a "Restart" the issue is not present and windows will boot fine. It appears that upon the shutdown sequence, the BCD is corrupted and the information is erased.
Most people would follow the onscreen prompts and insert the vista disc and proceed with a repair, when in 99% of cases, simply turning the pc off and back on again will be sufice and the system will then boot into windows fine. Try it, I can almost guareentee that it is the case.
If this is not the case, you may need to insert the installation disc and proceed to the repair OS screen, and select command prompt. Once in the command prompt;
Run bootrec
You will see a number of options;
/repairmbr
/repairbcd
/osscan
Repair BCD is the most essential command, as it locates missing OS's from BCD and links them, without modifying the other contents of BCD. Repair MBR is a dangerous command, and should only be used after running repairbcd as it will wipe the MBR and recreate it using the information from BCD. If the MBR is corrupted with false information from BCD, windows will be unable to repair this itself and a reinstall will be needed to correct it. Os Scan is a simple tool, used by repairbcd to scan for OS's not linked to either the MBR or the BCD.
Run bootrec /repairbcd
Answer Y once repairbcd has found the desired installation. You should recieve the message, "All tasks completed successfully"
Run bootrec /osscan
If osscan returns an OS that is not linked, that is a vista OS, you will need to;
Run bootrec /repairmbr
Repairmbr is fully automated. There is no need to explain it here.
Once these steps have been completed, your "generalised" BCD will no longer be "generalised" and the system should be able to start without problem. If you are presented with the same error, simply turn the system off and back on again, The system should boot fine. I have notified microsoft of the fact that this only occurs upon issuing of the shutdown command and hopefully they should release a fix.
WHEN ALL ELSE FAILS
If the problem persists even after performing all of these steps and restarting does not fix the issue, the problem directly extends from the installation and the system should be reinstalled with a fresh install, and with the primary drive only. After this, the service pack should be applied. Once this has been completed, additional drives should then be installed and configured.
USE OF BCDEDIT
In 90% of cases, this does not fix the issue. Only when pertaining to dual boot systems, will this correctely identify and fix the issue, because the "Generalised" BCD is not the problem, it is the actual "Unknown" entries in the BCD. If those are not present, then your issue is the "Generalisation" of BCD and not the actual entries in BCD, and this WILL NOT WORK.
| Divine Logix wrote: | |
|
Hopefully this has helped many people, and I am sorry that I could not provide a complete fix for this issue, but I have been able to point out why and hopefuly someone with a greater knowledge in those areas can provide a fix.
Reply:
90% of the time it only works on dual boot
I can boot into windows right now i dont want to loose that by doing something not already attempted
------------------------------------
Reply:
I can currently boot with my bios in ide mode- but my raid1 mirror is showing as independent drives (c and d)
I do a simple windows search for winload.exe on the C: drive and get nothing
that same search on the D: turns up winload.exe all over
When I look at I my BCD 'device partation=C:'
shouldnt this be D:?
If so is this just a simple bcdedit, reboot into the bios, change my bios from IDE mode to RAID mode, save to cmos then, theoretically boot into windows with my raid correct (showing as a singe drive C: )
Please someone correct me if I am wrong
C:\>bcdedit
Windows Boot Manager
--------------------
identifier {bootmgr}
device partition=C:
description Windows Boot Manager
locale en-US
inherit {globalsettings}
default {current}
resumeobject {8b18c20b-c12d-11db-afc2-ac36bbabc8b2}
displayorder {current}
toolsdisplayorder {memdiag}
timeout 30
Windows Boot Loader
-------------------
identifier {current}
device partition=C:
path \Windows\system32\winload.exe
description Microsoft Windows Vista
locale en-US
inherit {bootloadersettings}
osdevice partition=C:
systemroot \Windows
resumeobject {8b18c20b-c12d-11db-afc2-ac36bbabc8b2}
nx OptIn
vga No
quietboot Yes
------------------------------------
Reply:
2. confirmed a raid creation on the hardware level would format my C: and lose the os
installed intel matrix storage console under vista and it "failed to create volume" when I tried to mirror the C: (preserve data) to the D: (format loss of data).
This was supposed to be the intel solution to making a RAID1 in windows without doing a re-install of the os
The intel chip set is set to ENHANCED / RAID MODE so its supposed to work in creating under windows but its not because of that error.
Does anyone else know anything or have a clue about setting this up the best way?
------------------------------------
Reply:
| REHV wrote: | |
|
I have the same problem (RAID1 will only boot windows in sata mode), but winload.exe is visable on both the drives. Did you ever find a solution?
------------------------------------
Reply:
A good start but I had different options than
repairmbr/repairbcd
/osscan
So a good place to find further information is here: http://support.microsoft.com/kb/927392
However, even after I rectified the issue of getting the mbr to recognise the vista installation and rebooting a load of times I still get the error. Only way around it is to chose advanced options and disable digital signiture option.
Still won't boot proprly though!
------------------------------------
Reply:
Then when I tried to reboot the system, I get the error described above. So I appear to be the except to the rule. I do not have a dual boot set up, only one Hard Disk and only one O/S installed.
I am grateful for the info above and I will give it a try and report back on how I get on. Many thanks.
------------------------------------
Reply:
hi... today i had this problem. its my WinServer 2008. i did what it should be done in the first place, such as: the bootrec.
its still wont help startup my window, still shown \winload.exe > missing - corrupt.
i did also the second task, change the default into {ntldr}. after i restard the cpu, it shows a difference. beside the failed /winload.exe, it displays, failed /ntldr.
i change it back into default, and it goes back into /winload.exe missing / corrupt.
is there anything else that shud be done?
tq ~Fx~
------------------------------------
Reply:
Worked very well for a virtual Server 2008 (non R2) after restoring the VHD out of a backup.
the bootrec commands differ slightly when booting from the .iso, but not much.
Thanks
------------------------------------
Reply:
------------------------------------
Reply:
GReat man but in my worked with:
bootrec /fixmbr
bootrec /fixboot
bootrec /rebuildbcd
------------------------------------
Reply:
This fix saved me from a system restore on windows 8... 4 simple command lines saved from reinstalling over 30 games/apps.
Kudos!
------------------------------------
Reply:
Thanks a lot. Worked like a charm. I had a Windows 2008 Server restored and it didn't start. But thanks to your post I have managed to make it work again. Only some parameters on the bootrec have changed:
bootrec /fixmbr
bootrec /fixboot
bootrec /rebuildbcd
But nevertheless it worked.
------------------------------------
Reply:
Hello DivineLogix,
I have been trying to diagnose a laptop with the "corrupt winload.exe " problem. After cmd line entry "bcdedit.exe", everything in the portion pertaining to Windows Boot Loader is the same as yours EXCEPT the last line:
"nx OptIn".........mine says "nx Optout"
please advise. I tried C:\Windows\System32>bcdedit /set {nx}=OptIn, and
C:\Windows\System32>bcdedit /set nx=OptIn,but neither worked. Thanks very much in advance. p.s. This is a last ditch effort since I believe the hard drive is failing. Also, from Vista Recovery Environment\DISKPART-is there a way I get the data off the failing hd? since it's X:\Sources>, could I use xcopy ? or something like that? Thank you so much. Monika (ilovesecurity)
------------------------------------
Reply:
I installed a new Vista laptop, everything was great. Then I ran the updates and at some point it restarted and told me that Winload.exe was corrupt or missing. I tried bcdedit, repairing the system, whatever. Nothing worked.
Finally, I realized that the bcdedit path was pointing to \windows\system32\winload.exe and not \windows\system32\boot\winload.exe as it should.
Trying to modify this with bcdedit gave me error and didn't work. So, as a last and desperate option I simply copied winload.exe from the boot folder to its parent folder (\windows\system32\winload.exe), rebooted, and low and behold, Vista came back to life!
So, all you need to do is simply copy \windows\system32\boot\winload.exe to \windows\system32\winload.exe. Simple and easy solution. My guess is that some dude at Microsoft forgot to change the path :-)
Hope this helps
- Edited by Bardyupd Tuesday, October 13, 2015 8:35 PM
------------------------------------
Reply:
------------------------------------
Reply:
I battled with the winload.exe missing error for weeks, trying to clone a 256GB SSD onto a new 500GB SSD. After trying several cloning software options, I eventually captulated and created a Windows 8.1 installation disk in a final attempt to try to repair the MBR. Only when I ran the Windows installation disk did I eventually get an error message that a GPT formatted system was required. I reinstalled Windows without any problem once GPT formatting was selected.
It therefore seems that some of the new SSDs will not work in MBR format, even if they are much smaller than 2TB.
As an experiment, I cloned the new disk back onto the old disk and it worked first time.
------------------------------------
Reply:
One thing that seems to be missing in all these techniques is simply:-
chkdsk C: /f
The files might not be missing or corrupt, but simply inaccessible due to a chkdsk being required. You might need to do this after using a 3rd party disk management tool like GParted.
Regards - Tom Watson
------------------------------------
SCCM 70-243 Exam Questions
Hi
how many questions are there for SCCM 70-243 exam and it time duration ?
some of technet support says 60 some says 45
Reply:
Hi
how many questions are there for SCCM 70-243 exam and it time duration ?
some of technet support says 60 some says 45
Ok, I will bite why does it matter how many questions there are?
As for the length of the exam, this is all listed on the Microsoft training site.
Garth Jones
Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx
Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased
------------------------------------
Reply:
I wrote the Exam 70-243 and got 50 Questions.. All are answerable.
Regards
Prabha G
Thanks, Prabha G
------------------------------------
Reply:
------------------------------------
Reply:
Simon Dettling | msitproblog.com | @SimonDettling
------------------------------------
How to assign two IP address logical to a single client from DHCP server (suppose one is 192.168.109.98 and second is 192.168.10.98 in same Physical Network ?
Respected All,
Our problem is to assign two ip addresss for a single ethernet card or client from DHCP server.
How to assign two IP address logical to a single client from DHCP server (suppose one is 192.168.109.98 and second is 192.168.10.98) in same Physical Network ?
Regards
Sanjeev
Reply:
------------------------------------
Reply:
Sir, we need same setup in DHCP mode, not in static IP mode. That is true it is possible in static IP addressing mode, recently we have switch from static IP addressing mode to DHCP IP addressing mode. In this mode we wants to set both IP Address set automatically by DHCP server.
With regards
Sanjeev (Wait for solution)
------------------------------------
Data Flow Task with OLE DB Destination Oracle hangs
Hi guys,
Here you have our last nightmare:
We are developing a very straightforward process with the purpose of retrieving few rows (not more than 5 :) ) from a SQL Server 2014 table and insert them into a Oracle 12c table.
In order to do it we have created a SSIS package (we are on 2014 release) with a data flow task. This data flow simply contains a OLE DB Source (Native OLE DB Client 11,0) that redirects its output to a OLE DB destination component (Oracle 12c) -based on native Oracle OLE DB Provider-. Both tables have single column that is mapped on the destination component (column datatype SQL Server: int; column data type Oracle numeric (10))
When package its executed on debug mode we see that the rows are retrieved from SQL Server table but insert into Oracle tables is never completed and package remains hangs running forever the destination component without triggering any error.
Any idead about what prevents package to insert the rows on Oracle table?
Thx
Reply:
I answer my self :)
issue come from the fact that the Oracle 64 Ole db driver was not installed (only the 32-bits one).
Hope it helps someone with the same issue!
Alfons
------------------------------------
Surprisingly super-fast
This is really just an observation about good performance, better than hoped for.
I had a complex query that would sometimes run ten seconds, sometimes two minutes. Then it started running mostly two minutes. Looking at it, I realized I was already giving SQL Server about all the hints I could, but it was still looking at a lot of data that it didn't have to, apparently. So I did it old school, took it apart, selecting rows into #temps and using several simpler queries instead.
And now the thing just flies! I mean, I do this a lot, but this one is amazing me. I first pull about 20k rows (ranges from under 8k to over 40k, maybe 20k average) from a big table, just four or five ints and dates and bits and even better they come from an (nonclustered) index, which I guess is generally already in buffers. It then does a cross-join on these rows and puts the results, generally just a dozen or two, into another #temp, and then does some more stuff with that.
This is now running under 200ms, with correspondingly few reads, often under 100ms.
That just strikes me as crazy fast for what does after all involve pulling 20k values, persisting them to tempdb, and doing a cross-join on the unindexed temp.
So, thank you SQL Server, also thank you Intel for processor chips with big caches, because I have to figure that's a good part of what makes this run so fast.
(also, the history of this code is that it was previously written row-at-a-time cursors and would run for hours, so this is already a second rewrite ... and I just realized I could do a third and probably make it that much more efficient, it doesn't really have to be a cross-join all of the time, but we've got to be in the area of diminishing returns now, it's typically called a few times an hour with varying workloads)
This is also without benefit of memory-optimized tables or even column indexes, either of which should, in principle, help even more, if used.
Josh
Reply:
Josh,
I guess your approach did the trick of selecting limited rows in tempdb table and doing processing. This gave exact picture about data to optimizer and it made correct estimations and result was happy ending.
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from itMy TechNet Wiki Articles
MVP
------------------------------------
Reply:
I guess your approach did the trick of selecting limited rows in tempdb table and doing processing. This gave exact picture about data to optimizer and it made correct estimations and result was happy ending.
This is in praise of raw speed, and I was crediting the CPU quite a bit (this was done with maxdop=1 btw, although at such a fast speed I doubt anyone would normally generate a parallel plan for it anyway).
But I want to point out that, even with my manual optimizations, I should still give praise to the optimizer. I am cross-joining 20,000 rows, and if it generated 40,000,000 rows and then did the filtering it would be terribly slow. Though I'm not sure just what it does do. Actually, guess I should *look* at the execution plan!
On the negative side, the optimizer was not able to find this wonderful plan, whatever it is, when I presented it with a single, complex statement. We are running SQL 2014 Enterprise - without TF4199.
Actually I also realized today that I could tune the code further, I don't usually need the full cross-join after all, though when it's this fast already, I wonder if doing the extra setup will eat up all the improvement.
Endless fun with SQL Server!
Josh
------------------------------------
Possible to set an initial value for a file folder name in a document set?
- Changed type Geek2020 Thursday, October 25, 2018 1:18 PM
Reply:
I don't quite understand what do you want. Could you please provide more detail?
顺其自然地勇往直前！—Justin Liu
------------------------------------
SSAS Type 2 SCD and Hierarchy aggregations
Please and thank you for reading this and considering a solution. This may take a bit to explain so bare with me. I am new to SSAS and very proficient in SQL Server. I was tasked at my work to create a Data Warehouse to use with SSAS. First, I went through the entire Adventure Works tutorials Multidimensional Modeling.
https://msdn.microsoft.com/en-us/library/ms170208(v=sql.110).aspx
I wanted to get an idea of how the end user would be using the data. Then I did research on building the data warehouse. Decided to use Type 1 and Type 2 Dimensions as needed. Added surrogate keys as primary to all the dimension tables as well as leaving the business keys. Got my ETL up and running, watched it populate for a bit and started building SSAS cube.
Things appeared to look good until I started creating Hierarchies in the Customer dimension. My DW is a 1 tier snowflake schema. In this particular case, Geography is related to Customer and Customer is related to Fact Order table.
I am trying to provide aggregations that ignore history and use it, depending on the users choice. So I would like to have Customer Geography and Customer Historical Geography hierarchies. One would honor the changes taking place for customer records (StartDate & EndDate) and one would not. However, both would report on all records, not just orders linked to the current customer record.
However, I get either:
A: duplicate key error when processing
B: multiple rows on the Customer level when using the hierarchy
I can use Customer Number alone and get the one line for each customer. But if I add it to a hierarchy it forces me to add the surrogate key to the Key Columns of the attribute.
I have read so many articles on this that my head is about to explode. I have tried all the suggestions including making the customer number the key of the dimension. However, it still forces me to use the surrogate key or I get duplicate errors. And I can't use a Named Query because then it will only show me records in the fact table related to the current customer record.
I hope I have explained enough so that someone who is experienced can see the issue and suggest a solution. Any help would be greatly appreciated!
Cory
Retail Services Developer
- Edited by Cory Bonallo Monday, September 19, 2016 6:25 PM
Reply:
The key to understanding if you see or do not see SC2 data is if the Attribute you are displaying is linked directly to the Surrogate Key or not.
For instance, if I use the wizard to create a dimension, I am prompted for the key and name of the Primary Key attribute - which most people pick CustomerKey (for key) and CustomerFullName (for Name). This will not show a aggregate if there are multiple rows for same customer for SC2.
But, if I create the CustomerKey and CustomerName as separate attributes and hide the Key, there is a difference. If I drag CustomerName, one or more SC2 keys will be aggregated into the same CustomerName because I did not use CustomerKey as the Key and CustomerName as the Name for the attribute in SSAS.
AdventureWorks has a great example of this with the product Dimension.
With
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA
------------------------------------
Reply:
Retail Services Developer
------------------------------------
Reply:
That could be because in the Attribute relationship tab you have shown the relationship in the hierarchy in sequence like Year-Quarter-Month-Date.
You can avoid this (at the cost of performance) by making that attribute only related to the Key in the Attribute Relationship tab of the cube.
See the Production dimension in adventure works for an example.
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA
------------------------------------
Reply:
Did you mean Product dimension? I've checked and rechecked all the Attribute settings and relationships. It all looks setup exactly the same as the Product -> SubCategory -> Category hierarchy. Checked the DSV relationships and those are the same.
Account Name is dim key, CustomerKey is Key Column, Account Name is Name Column, Usage is Key
Account Name is bottom tier of hierarchy then City then State
Retail Services Developer
- Edited by Cory Bonallo Tuesday, September 20, 2016 6:55 PM
------------------------------------
Reply:
I have seen where an attribute like City can exist in multiple States.
If you have that setup in Attribute relationship like State-->City-->AccountName, then you will get the duplicate error. You could even get it if AccountName has values that are the same in different Cities or States.
If you want to keep that configuration in the Attribute Relationship tab, then you have to make the Key value property of the attribute City = State + City and add the City to the Name Value property of the attribute.
Here is a blog I did about this error - http://community.idera.com/blog/b/community_blog/posts/analysis-services-solving-hierarchy-errors-of-uniqueness
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA
------------------------------------
Reply:
Retail Services Developer
------------------------------------
Reply:
Supply more info see if that jogs something. This is sample of data of the customer records that are not rolling up. Business key is CustNum. Account limit is what caused the new record. Geography key stayed the same.
CustomerKey CustNum CusStat CusName AccLimit BeginDate EndDate GeographyKey
6662 700278 A Freeland Ace Hardware 7 2016-07-07 NULL 2469
2577 700278 A Freeland Ace Hardware 1 2016-06-21 2016-07-07 2469
Pivot Table sales totals. I expected one line...
| Freeland Ace Hardware (700278) | 357198.44 | 355227.84 |
| Freeland Ace Hardware (700278) | 971.48 | 969.48 |
Retail Services Developer
------------------------------------
Reply:
Anyone else have any ideas? Still have not found a solution for this issue. Thanks so much for your time!
Cory Bonallo
Retail Services Developer
------------------------------------
Reply:
Hi Cory,
If you need to provide Type I and Type II dimensions, you will need two dimensions. Type I will use the business key to connect to the fact table. The dimension might be a view on the Type II where it is the current record. The Type II dimension will use your surrogate key. In this way, your cube will have two dimensions for users to select from, depending on whether they want Type I or Type II. This opens a can of worms, as you will have to explain/train all your users what the difference is. A useful technique can be cube perspectives, where you give most users only one Type.
Hope that helps,
Richard
------------------------------------
Reply:
Retail Services Developer
------------------------------------
From a HTML Page (form) : write data directly into a TXT file
Hello,
Through a form (html code),
how to write the data from the form to a TXT file ?
If necessary to create a button inside the form, I'm agree.
(please, if it's possible not to use a VBS or PHP script)
Regards,
- Edited by Cerkyr Tuesday, September 27, 2016 1:55 PM
- Changed type Bill_Stewart Monday, October 31, 2016 6:21 PM
- Moved by Bill_Stewart Monday, October 31, 2016 6:21 PM Unanswerable help vampire question
Reply:
Please read the following to help you to ask a good question:
- Posting guidelines
- Handy tips for posting to this forum
- How to ask questions in a technical forum
- Rubber duck problem solving
- How to write a bad forum post
- Help Vampires: A Spotter's Guide
-- Bill Stewart [Bill_Stewart]
------------------------------------
Powershell script execution from C#
we are creating a web application to execute PowerShell script
We are getting output from PowerShell.Invoke()
The problem we are facing if provide multiple commands in script there is no way to figure out which output row belongs to which command
for e.g. Script is :
"DIR C:\
DIR D:\"
let's say I want to display output as
DIR C:\:
....................
......................
DIR D:\:
..........................
......................
But I am not able to figure out that from PSObject collection that which row belongs to which command
We are building a generic solution so user can provide any script so we can not do that on script level by asking user to modify his script
We want to figure out it on execution code itself
- Edited by Vivek_Jain Wednesday, September 28, 2016 5:23 AM
- Changed type Bill_Stewart Monday, October 31, 2016 6:20 PM
- Moved by Bill_Stewart Monday, October 31, 2016 6:21 PM Off-topic
Reply:
Your question doesn't make much sense.
The output from dir c/cd with be files from those different drives. Al files will be c:\... or d:\...
\_(ツ)_/
------------------------------------
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
Wish to revert to 1511 build from 1607 anniversary update
Hi,
I wish to get back my previous Windows build (1511 64 bit) after installing the anniversary update (from clean installation, wiped out all the files without backing up the system).
how could I do to get back the previous version? It is because some of the software is not compatible to the new system (display went black).
Thanks
Reply:
how long ago since you installed version 1607 ?
Microsoft allows users 10 days "grace period" to go back to previous build.
After 10 days, one will have to use a corresponding 1511 iso to reinstall. And, Microsoft no longer makes 1511 iso available to the public.
- Edited by david hk129 Tuesday, September 27, 2016 2:57 PM
------------------------------------
FileNotFound(riched20.dll) exception for Visio 2016 Pro for Office 365
Hi,
We are using Visio Drawing Control in our application. While we run the application, we are getting FileNotFound (riched20.dll) exception.
This is specific to Visio 2016 Pro for Office 365. When we ran our application against Visio 2016 Standard/Professional we don't see this error.
I tried copying the dll manually to the location where the application is expecting it to be but then I get these errors related to COM.
{"Retrieving the COM class factory for component with CLSID {48D937B7-EF81-4B3F-8696-678EAE15A241} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))."}
Based on the GUID, I could manage to find that this is related to SOLUTILS.dll.
We suspect that this issue is related to VFS.
Can some one from Microsoft help us on this.
Please do let me know if you need any information from my end.
Regards,
Naveen
Project Server 2013 Schedule Page Issue
Hi All,
I have got an issue when I am editing any project with the option edit in <g class="gr_ gr_24 gr-alert gr_gramm gr_run_anim Grammar only-ins doubleReplace replaceWithoutSep" data-gr-id="24" id="24">browser</g> in Project Server 2013, but the same is working when I am editing the project in Microsoft Project. The Schedule page shows as loading but can't view the WBS plan of that Project in edited mode. I have 4 PWA instances but its working in the other 3 PWA instances. Can anyone help me with this <g class="gr_ gr_9 gr-alert gr_gramm gr_run_anim Punctuation multiReplace" data-gr-id="9" id="9">issue.</g>
No comments:
Post a Comment