plese
Reply:
------------------------------------
Incremental statistics for clustered columnstore index?
Hi,
We have sql server 2014 enterprise edition. Until now we used regular partitioned tables and rows based partitioned clustered indexes (partition key is integer value, the same for all values within partition). Now, because of business requirements change, we'll have 10 times more data, and preliminary analysis showed that having partitioned clustered columnstore index has much better performance vs traditional partitioned clustered index.
We have table with more than 100 partitions, each partition has more than 300 million rows (very wide rows). We have scenario where we load staging table (with 300+ million rows) (25 minutes, 70GB of data), build clustered columnstore index on it (6-7 minutes), and then slide into the main table. We also sometimes slide partitions out of the main table. Therefore, distribution of partition key values changes on each of these operations. Problem is that if statistics are not up to date, db engine is not aware of new or deleted data, and it might go into scan across all partitions (instead of doing partition elimination).
Keeping in mind that incremental stats are not supported with columnstore indexes, how to update statistics on this table?
Any ideas?
Thanks
Pedja
- Changed type Ed Price - MSFTMicrosoft employee Thursday, December 15, 2016 5:46 AM No response from OP
Reply:
Pedja
------------------------------------
Reply:
Hi Pedja,
Please review the following blog to get more details about how to use incremental statistics in partition table.
http://sqlperformance.com/2015/05/sql-statistics/improving-maintenance-incremental-statistics
And in your scenario, you can update statistics on the table by adding "SAMPLE number PERCENT" or "RESAMPLE".
Thanks,
Lydia Zhang
Lydia Zhang
TechNet Community Support
------------------------------------
Reply:
Lydia,
this article does not mention columnstore indexes at all (incremental statistics are not supported on columnstore indexes), and that was my question, what could be approach as alternative. I am aware of incremental statistics on partitioned tables with regular clustered indexes, as I use them in production.
To further explain, dbcc show_statistics('tablename', <clustered columnstore index name>) does not show anything, even after I run update statistics <tablename> with any sample you want. When I select from the function that is explained in that article ( [sys].[dm_db_stats_properties_internal]), for indexid = 1 (clustered columnstore index), I get no result.
So I am afraid that down the road, when this table becomes 1-2 TB, when we slide one of these partitions in, queries against it won't do partition elimination, but scan the whole clustered columnstore index...
Pedja
- Edited by Pedja Stojakovic Thursday, June 16, 2016 2:00 PM
------------------------------------
Reply:
Does anyone have any further suggestions for Pedja?
Thanks!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Reply:
Pedja,
Have you made any progress with this?
Thanks!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Self-Signed Script
- Changed type Bill_Stewart Friday, December 30, 2016 8:06 PM
Reply:
- Create a self-signed cert. (This is really easy with IIS - selfssl.exe) There many website to explain how to do this.
- Export it as a .pfx file with the private key
- Run: signtool.exe sign /f CodeSigning.pfx /p password /t http://timestamp.verisign.com/scripts/timstamp.dll scriptfile.ps1
-Tony
------------------------------------
Reply:
help signing
help New-SelfSignedCertificate -full
Just run the CmdLet when you live in 2016. For the year 2006 use Tony's method.
\_(ツ)_/
------------------------------------
Reply:
Just run the CmdLet when you live in 2016. For the year 2006 use Tony's method.
\_(ツ)_/
He did say .NET 2.0 (ツ)
Old School:
- Use makecert.exe from the .NET 2.0 SDK to make the cert. Or use IIS & selfssl.exe
- Use signtool.exe from .NET
PowerShell (new school) method:
- Make cert with New-SelfSignedCertificate
- Sign file with Set-AuthenticodeSignature
You'll find this site helpful: Signing PowerShell scripts
It covers both methods.
- Edited by Tony MCP Saturday, October 29, 2016 4:43 AM
------------------------------------
Reply:
No - he said he installed the net 2 SDK which tells us nothing about the version of PowerShell installed.
\_(ツ)_/
------------------------------------
Reply:
No - he said he installed the net 2 SDK which tells us nothing about the version of PowerShell installed.
\_(ツ)_/
True. I reread his question and realized I misread the question. Anyhow, hopefully one of us helped him.
-Tony
------------------------------------
Reply:
V2 cert generator script. Does not require SDK.
https://gallery.technet.microsoft.com/scriptcenter/Self-signed-certificate-5920a7c6
\_(ツ)_/
------------------------------------
Reply:
- Create a self-signed cert. (This is really easy with IIS - selfssl.exe) There many website to explain how to do this.
- Export it as a .pfx file with the private key
- Run: signtool.exe sign /f CodeSigning.pfx /p password /t http://timestamp.verisign.com/scripts/timstamp.dll scriptfile.ps1
-Tony
I don't have IIS on Windows 10.
help signing
help New-SelfSignedCertificate -full
Just run the CmdLet when you live in 2016. For the year 2006 use Tony's method.
\_(ツ)_/
There is not a 1:1 correspondence between New-SelfSignedCertificate and makecert. For example, how would I detour around -sv root.pvk? I don't know how to make those accommodations. Also, there are no examples for code signing in New-SelfSignedCertificate's help. There are only examples for SSL, S/MIME, and client authentication. Just tacking on -TextExtension "2.5.29.37={text}1.3.6.1.5.5.7.3.3" is not enough.
Just run the CmdLet when you live in 2016. For the year 2006 use Tony's method.
\_(ツ)_/
He did say .NET 2.0 (ツ)
Old School:
- Use makecert.exe from the .NET 2.0 SDK to make the cert. Or use IIS & selfssl.exe
- Use signtool.exe from .NET
PowerShell (new school) method:
- Make cert with New-SelfSignedCertificate
- Sign file with Set-AuthenticodeSignature
You'll find this site helpful: Signing PowerShell scripts
It covers both methods.
You can't install the .NET 2.0 SDK on Windows 10. Geoff's article is not helpful because it depends on having the .NET 2.0 SDK installed.
V2 cert generator script. Does not require SDK.
https://gallery.technet.microsoft.com/scriptcenter/Self-signed-certificate-5920a7c6
no linksno links
\_(ツ)_/
I suppose I can use New-SelfSignedCertificateEx. But then what is the point of having New-SelfSignedCertificate in PowerShell 5.0?
There are no step-by-step instructions for creating a code signing certificate with New-SelfSignedCertificate. You also need to convert Geoff's instructions about creating a root certificate so the code signing certificate actually works.
------------------------------------
Reply:
On windows 10 from an elevated prompt:
Get-WindowsOptionalFeature -Online -FeatureName IIS-ManagementService
To install
Get-WindowsOptionalFeature -Online -FeatureName IIS-ManagementService | Enable-WindowsOptionalFeature -online -All
\_(ツ)_/
- Edited by jrv Sunday, October 30, 2016 12:16 AM
------------------------------------
Disk Cleanup System files hangs after October 27, 2016 updates
Reply:
Two computers experienced this problem. After running sfc /scannow disk cleanup worked fine on both computers. System file checker did find some corrupt files on one computer but not the other. Ran the system file checker on third computer without bothering to try disk cleanup first...disk cleanup ran fine on that computer too.
Just now on my laptop, ran disk cleanup and noticed top entry in system cleanup list, windows update files I think it was, says 3.99TB...my SSd is 128 GB!
It is obviously stuck too. Now for system file checker.
------------------------------------
Two issues with MS Office Small Business 2007 (Excel & Word)
1. In EXCEL, the column letters and row numbers have dotted lines under them and even more distracting; text entered into the cells have dotted underlines and odd formatting. Please see first screen capture below. Any suggestions to resolve?
2. Every time I open WORD, it goes through a "Configuration Process" before it actually starts. I've deleted the program and reinstalled it to no relief. Please see second screen capture below. Any suggestions to resolve?
Calling all Visio Gurus. October readers need feeding!
For Visio, please post in the Miscellaneous category!
==============
Hey you! No, not that person behind you. YOU!!!
Want to be a real-life virtual guru? (pun intended)
Do you want to win the love and admiration of the community you work in?
You can win REAL virtual medals and prove your skills, in a competition that is judged by real Microsoft judges!
Gurus who continue to shine soon get noticed!
Oh yes! We're talking inner circles! Nominations! New horizons!
Step up and stand out!
All you have to do is add an article to TechNet Wiki from your own specialist field. Something that fits into one of the categories listed on the submissions page. Copy in your own blog posts, a forum solution, a white paper, or just something you had to solve for your own day's work today.
Drop us some nifty knowledge, or superb snippets, and become MICROSOFT TECHNOLOGY GURU OF THE MONTH!
This is an official Microsoft TechNet recognition, where people such as yourselves can truly get noticed!
HOW TO WIN
1) Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
2) Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed)
3) Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favoured technology will help us learn the active members in each community.
More about TechNet Guru Awards
Thanks in advance!
Pete Laker
TechNet Wiki Community Council Member, Azure MVP, Wiki Ninja & TechNet Guru!
and...Ninja Ed
Guy who dances like ninjaEd Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
Reply:
Add a Visio category and I might add something.
Paul Herber, Engineering and software shapes for Visio<br/> <a href="http://www.paulherber.co.uk/">Paul Herber</a>
------------------------------------
Cursor
Hi
My Cursor is jumping about, please help me to fix this problem!
Reply:
If you have a wireless mouse, change the battery.
If not, clean the track ball.
If it still doesn't function correctly, replace the mouse as it may have become defective.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. "
------------------------------------
Concerning Multiple Desktops
You set whether Taskbar shows all Desktops or only one.
You can set whether Alt+Tab shows all or only one.
You can put Edge in other Desktops by taking a Tab, or a New Tab to Move to new window (Rt Clk) then, using Task View move or drag where wanted.
Of anything in Windows 10 I think I like the Multi Desktops Feature the most, best. Have used it daily 'forever' & find it very helpful & useful... servers a worthwhile purpose & one can make good use of it. Terrific how one can move around w/in it, too.
Cheers,
Drew
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
Reply:
You are right, Drew. It's a wonderful feature. People's eyes bug out when they see how it can help them organize their work. Just the WIN+TAB features (aka "Expose") is an efficiency boost. There are still some items on my wish list for multiple desktops, but on the whole, I think Microsoft has hit a home run with this feature in Win10. Here's my wish list:
* Hotkeys mapped to particular desktops (ie. WIN+SHFT+1, +2, +3, etc.) At present I'm using WIN+TAB, TAB to move focus down to the various desktops, ARROW to my desktop of choice, ENTER to move focus to that desktop. It's a smooth operation but a hotkey for each desktop would be more efficient.
* Hotkey to move window to a different desktop (ie. WIN+CTRL+SHFT+1, +2, +3, etc.) Using the mouse for this at present, but I do it so much throughout the day a hotkey would be more efficient.
* Different Background/Color Schemes on each desktop. A visual indicator (a name, or color, perhaps) to indicate which desktop I'm at would be helpful. Users I've observed interacting with the multiple desktops tend to group applications, and I've noticed they take a few seconds to adjust, sometimes asking "No what desktop was this?"
I'm seeing a lot of discussion about multiple desktops on the web, but I'm not running into much of it in the wild. In fact, I'm surprised by how many fellow Win10 users are unaware of this feature. Which is probably a compliment to Microsoft's design choices; they made it seamless and thus hidden.
------------------------------------
Reply:
I absolutely agree, there should be an indicator as to which desktop is in use & a K/B way to pick a desktop. I, too, have had this same thought for a long time... likely there are many Users share the same feeling.
The Win 10 Build Team should see this exchange ^. Also, mention it via Feedback Hub, of course.
It's my understanding that due to how multi desktops is done, having different backgrounds is impossible.
Cheers,
Drew
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
- Edited by Drew1903 Wednesday, October 26, 2016 6:36 AM
------------------------------------
Reply:
Ctrl+Win and the <-- or --> will let one 'scroll' through all the desktops in use (to select, stopping on the one wanted). I wasn't sure if you knew this ^, already, or not.
Cheers,
Drew
Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com
------------------------------------
KB3197954 has now been released to the general public (non-Insiders).
Microsoft has released a new cumulative update KB3197954 via Windows Update to Windows 10 PC and Mobile.
This will bring Windows 10 from 14393.321 to Build 14393.351.
Manual Download KB3197954 for PC:
See also: How to Install a CAB File in Windows 10
- 64-bit (x64) http://download.windowsupdate.com/d/...de95a9dcc3.cab
- 32-bit (x86) http://download.windowsupdate.com/c/...3f39bfd2c3.cab
- Changed type david hk129 Thursday, October 27, 2016 8:09 PM
- Edited by david hk129 Thursday, October 27, 2016 8:11 PM
Reply:
14393.351 installed.
------------------------------------
Reply:
I guess, you just need to wait until it finishes itself. Be patient!
Now i have 14393.351.
I did install on my desktop pc and laptop, both went well.
Good luck guys!
Czecher
------------------------------------
BizTalk Server 2016 Azure VM image now available!
Hello BizTalk techies,
For those of you that missed our announcements here and here, BizTalk Server 2016 has been released to manufacturing (RTM) today! What does this mean? Well, we now go through the process of making the media available across all channels which takes a little time to complete. But we know you can't wait for all that so if you want to get started right now, we've already released the Enterprise Edition gallery image here in Azure. It should also be appearing at http://portal.azure.com within the next 24 hours. Find out more about BizTalk Server 2016 here.
Read more: BizTalk Server 2016 Azure VM image now available!
Thanks,
If my reply is helpful please mark as Answer or vote as Helpful.
My blog | Twitter | LinkedIn
This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
- Changed type [Kamlesh Kumar]Moderator Friday, October 28, 2016 8:37 PM Discussion type
Google zoom changing weirdly on W10
Since I started using PC with Windows 10, Google has sometimes changed its zoom levels. Why I believe this is an issue of Windows and not Google:
- It only happened with Windows 10 (which btw is rubbish, bring back Windows 7).
- The zoom only changes whenever my PC gets an update.
The changes include the size of web sites, font and tool bar.
I'd like Microsoft to fix this asap, as the changed zoom level makes the usage of certain web sites nearly impossible, and the smaller font size on the titles of tabs looks really unaesthetic and disturbing.
Btw sorry for possibly wrong sub forum, none of the options really fit.
- Moved by Carey FrischMVP Saturday, October 29, 2016 6:04 PM Relocated
STUCK on white spinning start up dots
A few days ago my laptop (Asus X552C) started playing up, for example whenever I pressed 'sleep' it would shut down anyway.
Next, the laptop completely froze; Spotify tried to reinstall, chrome wouldn't load and was stuck on the blue spinning circle etc.
Therefore I had to hold the power button down in order to shut the laptop down however now, when I press the power button I can't get past the white spinning dots at the bottom of the screen.
I am able to get into safe mode however troubleshooting has not as of yet been able to pick up anything and resetting came back as not possible.
Also when I try and scan the device with Windows defender it shuts down after about 2 hours of scanning.
If anybody knows how to deal with this, please help!!
Thank you.
Reply:
Having Fast Boot turned [ON] bypasses certain compatibility steps during the startup processes. When I turned Fast Boot [OFF], my spinning dots disappeared and the Windows 10 booted properly. I was not surprised to see then another program trying to update. Perhaps two incompatible update processes were trying to run simultaneously.
To turn off Fast Boot:
Use power button to turn computer off, then restart and repeatedly press F12 to get the Boot Device Menu.
Select POST behavior. Select Fast Boot and set to [OFF] status. Save and exit.
Hopefully, your computer will continue to start up successfully. At least, mine did.
After the problem has been resolved, and you have successfully rebooted a couple of times with Fast Boot [OFF], you will want to turn Fast Boot back [ON]. Otherwise, every restart will be painfully slow.
Let us know if this works for you.
------------------------------------
Windows 10 1607 update not working with Remote Desktop Gateway server
Complete problem statement and hotfix.....
Windows 32 bit and Windows 10 update 1607 does not like eachother. . .
The remote desktop wont work after upgrading to 1607.
A hotfix:
- Delete the remote desktop files after upgrading. File names are "mstsc.exe and mstscax.dll". Located in System32 folder. Follow this delete guide: http://www.howtogeek.com/howto/windows-vista/how-to-delete-a-system-file-in-windows-vista/
- Paste the old before update 1607 mstsc files to system32 folder. Here they are zipped: https://1drv.ms/u/s!Akwb-5DXRw0L-iNMOKucQtbGeIeR
Sry for no click links, my account isent veryfied. First post.
Hope it helps
- Changed type MeipoXuMicrosoft contingent staff Thursday, September 29, 2016 2:29 AM sharing
Reply:
Hi Mikethk,
Are you sharing a troubleshoot experience?
Thanks for sharing. You could try to submit the issue with the "Feedback" hub. We have noticed the similar issue and we have submitted this on our side.
Best regards
Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com
- Edited by MeipoXuMicrosoft contingent staff Thursday, September 29, 2016 2:29 AM
------------------------------------
Reply:
Thank you. Worked for me.
It seems that there is a bug in the RPC control (in 32bit mode) and fix by Microsoft will be released on 28th October through Microsoft Update. KB version will be made public after the internal testing process from Microsoft is complete.
- Edited by OLMeijer Thursday, October 6, 2016 9:09 AM
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
dual boot problem
Hello!
Please help me!
I have a ThinkPad T460s laptop with windows 10 host os, i tried to make a dual boot machine and i've done already with linux install.
I can't add in EasyBCD other boot options because it said "machine is currently booting in EFI mode"
so i changed in BIOS from uefi to both where first is legacy, and i disabled the secure boot option too...
Doesn't work, if i change from uefi to legacy the laptop doesn't work...
please somebody tell me how the f*ck can i make a dual boot machine nowadays with this hateful new bios technology
thank you very much!
Reply:
J W Stuart: http://www.pagestart.com
Never be afraid to ask. This forum has some of the best people in the world available to help.
------------------------------------
Reply:
thank you!
now i try to reinstall the windows in legacy mode, and after i try to install linux distro ...
maybe it will help...
steps now what i did ... restart, in bios changed from uefi to legacy, boot from windows recovery usb, install win10.... i will get a win 10 (legacy boot) ..am i right? so after i can install linux and dual boot should be works?
no .... after recovery can't boot now ... grrrr
- Edited by 11ka Friday, October 28, 2016 6:09 PM
------------------------------------
FREE UPGRADE REVERTS TO PREVIOUS WINDOWS AUTOMATICALLY
Performance Rule by Visual Studio Authoring Console Powershell ISSUE
Hi,
i'm new worker on SCOM and i have some problem with collection data from a custom rule created with Visual studio Authoring Extension. This rule execute a script powershell and set a simple property bag with two information. I write this code after reading the article "http://social.technet.microsoft.com/wiki/contents/articles/6287.visual-studio-authoring-extensions-example-management-pack.aspx"
I create a new MP with Discovery, Datasource and ProbeModule and Rule similar to the approach of link.
This is the script ps:
Remove-PSSnapin Citrix.XenApp.Commands
Add-PSSnapin Citrix.XenApp.Commands
$localserver =get-content env:computername
$api= New-Object -comObject 'MOM.ScriptAPI'
$countActiveserverlocal = (Get-XASession -servername $localserver| where-object {$_.State -eq "Active"}|).Count
$stream = [System.IO.StreamWriter] "C:\SCOM_utils\Output\citrix_sessioncust.txt"
$stream.WriteLine("$localserver,$countActiveserverlocal")
$stream.close()
$api.LogScriptEvent('ActiveSession.ps1',10022,4,$localserver+$countActiveserverlocal)
$bag = $api.CreatePropertyBag()
$bag.AddValue("ServerCitrix", $localserver )
$bag.AddValue("NumberSessionActive", $countActiveserverlocal)
$bag
There are not error in script.
I log the information in a file citrix_sessioncust.txt everytime run rule and these data are correct but with rule i obtain ever:
Event id: 31876
Data item returned no information for parameter '$Data/Property[@Name='ServerCitrix']$'
This usually indicates that the query is incorrect.
One or more workflows were affected by this.
Workflow name: CitrixMP.CollectSessionActive
Instance name: W8PUBCOCT0204.---.----
Instance ID: ...
Event id: 11052
Module was unable to convert parameter to a double value
Original parameter: '$Data/Property[@Name='NumberSessionActive']$'
Parameter after $Data replacement: ''
Error: 0x80020005
Details: Type mismatch.
One or more workflows were affected by this.
Workflow name: CitrixMP.CollectSessionActive
Instance name: W8PUBCOCT0204.---.---
Instance ID: ...
My mode to get the values is in this snapin:
<ConditionDetection ID="MapToPerf" TypeID="Perf!System.Performance.DataGenericMapper">
<ObjectName>ServerCitrix</ObjectName>
<CounterName>Citrix Active Session</CounterName>
<InstanceName>$Data/Property[@Name='ServerCitrix']$</InstanceName>
<Value>$Data/Property[@Name='NumberSessionActive']$</Value>
</ConditionDetection>
I read many articles but nothing resolve the no-read problem of these properties.
I use SCOM 2012
Any suggestion?
Sorry for my bad english!:)
- Changed type Niki Han Monday, November 4, 2013 10:50 AM
Reply:
Did you ever find a solution for this problem?
I'm experiencing the exact same symptoms, and can't figure out what is going wrong.
------------------------------------
Reply:
Same issue here. Notice that the SCOM folks haven't chimed in. Probably don't know the answer. They're usually quiet because they'd be expected to solve it.
Saw some old recommendations for adding a patch to Server 2008, but we're at 2012 R2.
https://danmyhre.wordpress.com/2012/12/18/generic-performance-mapper-module-failed-execution/
------------------------------------
Reply:
So in case anyone cares, I got around this issue by converting my value to a double prior to passing it to the property bag.
$bag.AddValue("MyVal",[double]$outVal)
So since no one knows why SCOM can't convert to double, don't make it convert, pass the double in the script.
------------------------------------
How do I return the normalised, inner identity of a user in the User-Name AVP of an Access-Accept?
Is it possible to configure NPS to return the normalised, inner identity of a client in the User-Name AVP of an Access-Accept to cope with anonymous outer identities?
Where 802.1X authentication takes place and an anonymous outer identity is used (meaning that it differs from the inner identity) with a TLS based EAP, such as PEAP, it should be possible to return the inner identity in the Access-Accept so that the NAS has the ability to work with the 'real' identity of the user. Can NPS do this? How would this be configured?
The User-Name AVP of an Access-Accept also provides a RADIUS server the ability to return a users' identity normalised. (For example, where domain\user is supplied by a user, the RADIUS server can always respond with user@fqdn.) Can NPS do this? How would this be configured?
Increasing numbers of features are being implemented in switches and access points, such as L7 application visibility and control, so it is a significant operational concern that such devices work with an accurate identity, one that cannot be spoofed with an anonymous outer identity and is consistent for a discrete user.
If this is not possible today, how would one go about making a design change request to Microsoft to accomplish this or talk to the development team? Is this an oversight? Competing RADIUS servers such as FreeRADIUS and Radiator have this ability when configured.
For reference, this is RADIUS standard behaviour.
RFC 2865 states in Section 5.1:
[The User-Name AVP] MAY be sent in an Access-Accept packet, in which case the client SHOULD use the name returned in the Access-Accept packet in all Accounting-Request packets for this session.
RFC 3579 states in Section 3:
The User-Name attribute within the Access-Accept packet need not be the same as the User-Name attribute in the Access-Request.
Furthermore, where federated authentication has taken place, such as in eduroam, and a User-Name AVP has not been returned in the Access-Accept yet a Chargeable-User-Identity has after being requested, it should be possible to configure the RADIUS implementation to add a User-Name AVP set to cui@realm to the Access-Accept it sends on to the NAS so that it gets an identity that identifies the user with a constant identifier.
Is support for Chargeable-User-Identity (RFC 4372) support ever planned for NPS?
See:
Thanks!
Nick
Reply:
------------------------------------
Reply:
Hi Nick,
Thanks for the post.
As you have opened a support case with Microsoft Technical support, I would like to archive this thread if you do not mind.
If you have any further concern, please feel free to let us know.
In addition, it is appreciated that if you can post solution when the issue is resolved so that it can benefit others.
Best Regards.
Jeremy Wu
TechNet Community Support
------------------------------------
Reply:
That's more than fine. Sorry if I have messed the system around! After posting, I realised I wanted a more formal response so opened a case.
I will post back here to let others know the outcome.
Thanks,
Nick
(The support case number, for anybody who is interested, is SR 113043010404466, titled "Normalising and returning inner identity in the User-Name AVP of a RADIUS Access-Accept".)
------------------------------------
Reply:
This had been escalated to a support team lead and is now awaiting comment from a debugging engineer.
As I see NPS as being the facilitator of an identity spoofing vulnerability here, although I do not expect a quick resolution, I am quietly hopeful for the team to be amenable to reasoned argument and for some good news at the end of it!
Will continue to update back here as and when I hear more.
------------------------------------
Reply:
Try this Extension for Microsoft NPS adding attributes for compatibility with eduroam.
It adds "User-Name" attribute to Access-Accept.
------------------------------------
Reply:
Hi Nick,
I know this is an oldie, but did you ever get a resolution / answer to your question?
Kind regards,
Dimitry Schoenmakers
------------------------------------
Reply:
Hi Nick,
Any news about this issue?
Best regards,
Hugo Veiga
------------------------------------
Reply:
------------------------------------
Reply:
Would love to hear back concerning the outcome of this.
Thanks.
------------------------------------
Reply:
FYI - Can confirm the Eduroam-MS extension code works as intended in NPS on Windows 2012 R2 Server for anyone else in a similar situation as myself.
Also, anyone who's not a developer, but knows just enough to compile some code... I ran into the following when trying to test this out myself, so I'm sharing my struggles in the hopes it helps some other poor Googler out there:
"
Dependency Walker was key here for me. After successfully compiling my NPS extension DLL (Remember to match your server platform re: 32/64 bit!), I really struggled to get NPS to load it. It would simply respond with a 0x7E error (Event Log). This was initially interpreted as NPS somehow not being able to properly locate the DLL I was trying to load (Is it in a PATH variable location? Did I screw up the NPS Extension registry keys somehow?), but in reality, actually meant that a dependency /within/ the DLL wasn't able to be located.Running Dependency Walker *on the target NPS server* and pointing it at the extension DLL will indicate which dependency the server isn't able to source. In my particular case it was MSVCR120.DLL, and will likely vary depending on whether you are compiling a Release or Debug build of your DLL and what version of the Build Tools was used to compile it (version 120 in my case). A quick google for the missing DLL will usually point you in the direction of a Visual C++ Redistributable package you can install on the server to meet the dependency.
I hope this information helps someone else. I sure wish I could have found it about 3 days ago myself.
"
Cheers!
newp
------------------------------------
MDX Month to Date Comparitive
Hi folks,
I want to track cumulative Sales within a month, as a comparison for the same day of the same Month in previous Years.
So,
I want the following:
Slicer (Filter) : Month of Year = [Date].[Months]
Rows : Day of Month = [Date].[Days]
Columns : Year = [Date].[Calendar].[Year]
Measure : SalesUnits-MonthToDate = [Measures].[Quantity]
Getting this with SalesUnits for each day is easy:
{[Date].[Calendar].[Year].&[2014]:[Date].[Calendar].[Year].&[2016]} ON 0
, {[Date].[Days].[Day Of Month]} ON 1
FROM [Sales]
WHERE [Date].[Months].&[8]
However, getting it for Cumulative Month to Date calculated values, is proving a little tricky.
WITH
MEMBER [Measures].[QtyMTD]
AS Aggregate (
PeriodsToDate (
[Date].[Calendar].[Month]
,[Date].[Calendar].CurrentMember
)
,[Measures].[Quantity]
)
SELECT NON EMPTY
CROSSJOIN(
{[Date].[Calendar].[Year].&[2014]:[Date].[Calendar].[Year].&[2016]}
, {[Measures].[Quantity], [Measures].[QtyMTD]}
) ON 0
, {[Date].[Days].[Day Of Month]} ON 1
FROM [Sales]
WHERE [Date].[Months].&[8]
My results are empty for QtyMTD, and I'm stumped. In this query, I would expect to see another three columns for QtyMTD for 2014, 2015, 2016. Any help would be greatly appreciated.
How would I do this?
So, I want the Green Data below, not the Blue Data
| Day | 2014 | 2015 | 2016 | Day | 2014 | 2015 | 2016 |
| 1 | 336 | 20 | 0 | 1 | 336 | 20 | 0 |
| 2 | 0 | 0 | 842 | 2 | 336 | 20 | 842 |
| 3 | 0 | 1,199 | 300 | 3 | 336 | 1,219 | 1,142 |
| 4 | 402 | 2,593 | 1,693 | 4 | 738 | 3,812 | 2,835 |
| 5 | 3,396 | 981 | 1,905 | 5 | 4,134 | 4,793 | 4,740 |
| 6 | 2,329 | 2,488 | 0 | 6 | 6,463 | 7,281 | 4,740 |
| 7 | 1,825 | 3,602 | 0 | 7 | 8,288 | 10,883 | 4,740 |
| 8 | 917 | 0 | 2,486 | 8 | 9,205 | 10,883 | 7,226 |
| 9 | 393 | 0 | 0 | 9 | 9,598 | 10,883 | 7,226 |
| 10 | -548 | 0 | 603 | 10 | 9,050 | 10,883 | 7,829 |
| 11 | 1,192 | 3,140 | 1,306 | 11 | 10,242 | 14,023 | 9,135 |
| 12 | 2,811 | 1,740 | 1,640 | 12 | 13,053 | 15,763 | 10,775 |
| 13 | 1,109 | 2,425 | 96 | 13 | 14,162 | 18,188 | 10,871 |
| 14 | 3,443 | 1,756 | 0 | 14 | 17,605 | 19,944 | 10,871 |
| 15 | 2,204 | 0 | 2,037 | 15 | 19,809 | 19,944 | 12,908 |
| 16 | 572 | 0 | 1,351 | 16 | 20,381 | 19,944 | 14,259 |
| 17 | 0 | 3,096 | 943 | 17 | 20,381 | 23,040 | 15,202 |
| 18 | 2,689 | 2,457 | 1,434 | 18 | 23,070 | 25,497 | 16,636 |
| 19 | 1,870 | 3,271 | 2,285 | 19 | 24,940 | 28,768 | 18,921 |
| 20 | 1,739 | 3,216 | 0 | 20 | 26,679 | 31,984 | 18,921 |
| 21 | 3,293 | 4,248 | 0 | 21 | 29,972 | 36,232 | 18,921 |
| 22 | 3,122 | 2,189 | 4,832 | 22 | 33,094 | 38,421 | 23,753 |
| 23 | 1,101 | 0 | 2,843 | 23 | 34,195 | 38,421 | 26,596 |
| 24 | 0 | 18 | 2,569 | 24 | 34,195 | 38,439 | 29,165 |
| 25 | 2,877 | 7,444 | 7,344 | 25 | 37,072 | 45,883 | 36,509 |
| 26 | 3,555 | 2,917 | 2,342 | 26 | 40,627 | 48,800 | 38,851 |
| 27 | 2,119 | 5,400 | 2,060 | 27 | 42,746 | 54,200 | 40,911 |
| 28 | 767 | 3,128 | 0 | 28 | 43,513 | 57,328 | 40,911 |
| 29 | 3,497 | 101 | 4,122 | 29 | 47,010 | 57,429 | 45,033 |
| 30 | 2,481 | 0 | 7,575 | 30 | 49,491 | 57,429 | 52,608 |
| 31 | 2,572 | 2,493 | 6,655 | 31 | 52,063 | 59,922 | 59,263 |
Heeeeelllllppp!
Blue Peter
- Edited by Peter Wright (social) Thursday, October 20, 2016 4:01 PM
Reply:
------------------------------------
Sharepoint: How to add a wait dialog when Edit an Item(javascript)
Hello everybody,
I want to show a wait dilalog when click on "edit item" in the Edit Control Block, I know it can be displayed If I call SP.UI.ModalDialog.showWaitScreenWithNoClose("Please wait a moment", ""), SO what I need to do it modify the "OnClick" event for "Edit Item" action.
The difficulty is that The ECB Options are rendered after we click the "..."(along the Title field), it's not rendered as the page load, SO I can not get the "Edit Item" option when the page load with javascript.
Anyone can help me?
Thanks in advance.
Reply:
$(document).ready(function() {
$('#BUTTONID').click(function() { #your code here });
});
If this is helpful please mark it so. Also if this solved your problem mark as answer.
- Edited by taylor.l Friday, October 28, 2016 7:36 AM
------------------------------------
Apply Custom Filter Views on Project center Programatically
Hi All ,
I am working on Project Online 2013 and come across one requirement where user wants customize project center view based on customfilter.
Scenario : Based on the user role when user try to change the view from ribbon dropdown. Apply custom filter based on the given Column.
Solution :
var PMView = "f43163b6-847f-4e01-9e05-71db319225f6";
//To get current view Id
var ProjCenterComp=projectCenterComponent.get_GridSatellite();
var viewid=ProjCenterComp.get_CurrentView()["uid"];
//Check whether current view is matching your condition
if(viewid==PMView)
{
if(userRole=="Business User")
{
//custom Filter query
var xmlQueryfltr="<Filter><FieldComparison><Field>RES_NAME</Field><Operator>Equals</Operator><Operand>"+Loginname+"</Operand></FieldComparison></Filter>";
//This statement directly render your view in project center
projectCenterComponent.get_GridSatellite().Filter(xmlQueryfltr, null);
}
}
To Create xml Query
1.go in to the normal custom filter option provided by project online on ribbon select the filter which you want to apply and click on ok.
2. Go the Browser console and hit below query
var x=projectCenterComponent.get_GridSatellite()
x.get_FilterState()
Amey Pusalkar
No comments:
Post a Comment