sending parameter value to SSRS URL
HI ,
could any one explain how to send parameter value to SSRS URL.
Quick response is highly appreciated.
Best Regards,
Reply:
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
------------------------------------
Reply:
------------------------------------
After SCCM 1610 upgrade replication getting failed on new global data type Cloudproxy_global and RLA
After SCCM 1610 upgrade replication, getting failed on new global data type Cloudproxy_global and RLA
In CAS when we check in database monitoring , link state is active in all Primary servers . But when we connect to Primary server and then we find link state as failed below CAS and Primary . All replication group are active except only two global data type Cloudproxy_global and RLA which we found in replication detail. On sql also we found the same status through spdiagdrs.
we checked the rcmcontrol.log no error related to replication failure . We checked the replication interval is 1 min and in initialization details , it is 100 % for every data type including Cloudproxy_global and RLA.
Also we are not using cloud management gateway feature.
Please advice if anybody else faced similar issue and what can be done to fix the same.
following feature are enabled just for information
| VPNv2 support for 3rd party providers | Release | On |
| Windows Store for Business Integration | Release | On |
| VPN for Windows 10 | Release | On |
| Passport for Work | Release | On |
| Switch Software Update Point | Release | On |
| Manage duplicate hardware identifiers | Release | On |
| Windows Defender Advanced Threat Protection | Release | On |
| Pre-release - Server groups | Pre-release | On |
| Windows 10 device health attestation support | Release | On |
| Pre-Declare Corporate Owned Devices | Release | On |
Also manually copied the RLA.PUB in RCM box , it has successfully applied the BCP
.........................................
info from rcmctrl.log
Changed the Replication Phase value to: 9 SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)Checking if initialization request is needed for replication group RLA from site CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Checking if there are bcp file to apply for replication group RLA from site CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
found a tracking guid, searching through .init files. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Checking bcpDirectory D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Found files for publication RLA-CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Publication names match. Checking vesrion. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Found our tracking guid SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Initializing to version number 81853785. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Publication RLA has ID 31. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Flushing DRS queue messages coming from CAS for replication group RLA. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:32 AM 10220 (0x27EC)
Executing pre-snapshot stored procedures for group RLA. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 10220 (0x27EC)
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 11948 (0x2EAC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 11948 (0x2EAC)
SQL>>>update vAlertVariable_G set Value_Int = 0 where TypeID=1108 and TypeInstanceID=dbo.fnGetSiteCode() and Value_Int!=0 SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 11948 (0x2EAC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 11948 (0x2EAC)
Rcm control is waiting for file change notification or timeout after 60 seconds. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 11948 (0x2EAC)
Pre-snapshot stored procedures for group RLA finished. Applying bcp files. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:33 AM 10220 (0x27EC)
Removing old data for global table ... [EXEC spSMSTruncateGlobalTable RLA_DynamicSqlQueries] SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Rowcount from file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_DynamicSqlQueries.bcp.rowcount] is [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Successfully bulk copied file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_DynamicSqlQueries.bcp] into table [RLA_DynamicSqlQueries] with rows [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Removing old data for global table ... [EXEC spSMSTruncateGlobalTable RLA_DynamicSqlRules] SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Rowcount from file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_DynamicSqlRules.bcp.rowcount] is [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Successfully bulk copied file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_DynamicSqlRules.bcp] into table [RLA_DynamicSqlRules] with rows [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Removing old data for global table ... [EXEC spSMSTruncateGlobalTable RLA_Manifest] SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Rowcount from file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_Manifest.bcp.rowcount] is [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Successfully bulk copied file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_Manifest.bcp] into table [RLA_Manifest] with rows [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:34 AM 10220 (0x27EC)
Removing old data for global table ... [EXEC spSMSTruncateGlobalTable RLA_RuleLocalizedData] SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
Rowcount from file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_RuleLocalizedData.bcp.rowcount] is [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
Successfully bulk copied file [D:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\6AD70286-F991-47ED-A3DB-28173C84DB0F\RLA_RuleLocalizedData.bcp] into table [RLA_RuleLocalizedData] with rows [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
Bcp files have been applied. Executing post-snapshot stored procedures for group RLA. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
Post-snapshot stored procedures for group RLA finished. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>SELECT SC.SiteType FROM SMSData S INNER JOIN SC_SiteDefinition SC ON SC.SiteCode = S.ThisSiteCode SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>SELECT dbo.fnIsSnapshotInitializing(N'Site Control Data', N'') SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>select DateLastModified from SiteControl where SiteCode = N'PR1' SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
STATMSG: ID=7805 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_REPLICATION_CONFIGURATION_MONITOR" SYS=AMDC2SCM01.AMERICAS.MEDIA.GLOBAL.LOC SITE=PR1 PID=10768 TID=10220 GMTDATE=Fri Dec 30 11:26:35.930 2016 ISTR0="RLA" ISTR1="CAS" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
Sent InitFinished message to CAS for replication ID 31. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:35 AM 10220 (0x27EC)
Inbox notification tiggered. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:36 AM 11948 (0x2EAC)
Processing replication pattern site. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:36 AM 10220 (0x27EC)
Changed the Replication Phase value to: 11 SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:36 AM 10220 (0x27EC)
Processing Replication success. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:36 AM 3188 (0x0C74)
Cleaning the RCM inbox if there are any *.RCM files for further change notifications.... SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
Initializing RCM. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
SQL>>>select SiteCode from SC_SiteDefinition where ParentSiteCode = N'' SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
SQL>>>>> Done. SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
SQL>>>set quoted_identifier on;set ansi_warnings on;set ansi_padding on;set ansi_nulls on;set concat_null_yields_null on;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_REPLICATION_CONFIGURATION_MONITOR 12/30/2016 6:26:37 AM 11948 (0x2EAC)
- Edited by Kaushal Singh131 Friday, December 30, 2016 11:37 AM
Reply:
I have exact same issue after 1610 upgrade (additionally OSReadiness Data group)...
opened an MS case
- Edited by jj12345 Thursday, January 12, 2017 10:01 AM
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Dimension
Can't index a network drive, so can't put in Library
I keep my pictures on a file server on my network. I wanted to add the relevant location to my Pictures Library, but it refuses, saying I can't add a non-indexed location to the library.
So, I need the Search Indexer to index a network drive, but it seems impossible to do so. Control Panel | Indexing Options only offers the hard disks on my own PC.
I can't believe Libraries won't work with networked drives. So what do I do?
Could anyone help? Thanks.
- Changed type Nicholas Li Wednesday, February 11, 2009 4:30 AM
Reply:
I keep my pictures on a file server on my network. I wanted to add the relevant location to my Pictures Library, but it refuses, saying I can't add a non-indexed location to the library.
To be specific, the message is:
"This folder cannot be included because it is on a share that is not indexed".
And there seems to be no way of indexing it. I've mapped it to a drive letter, and that hasn't helped.
------------------------------------
Reply:
------------------------------------
Reply:
"Can I include a folder that isn't always available on my computer?
You can include folders from locations that aren't always accessible by your computer (such as removable drives or networks), but you won't be able to access the contents of those folders unless the drive or network is connected.
Although network folders can be included in libraries, searches will likely be slow because the contents of those folders can't be indexed."
So, I'm ok that this help message isn't correct (well, I think someone in the team have not exactly understand what should be done with libraries ?)
I have a server with indexed drives, but that doesn't really work; I add a network drive from my server in windows 7 (something like Z:) and I want to add Music from server into my libraries ;
Seems to be impossible ...
Did you have an idea ?
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
I think is the same with Pictures or Music folder on other machines.
But if you remove WMC in Windows turn on/off features, the network folders disappears from library/video.
Let me know if work
------------------------------------
Reply:
Thank you!
------------------------------------
Reply:
It involves creating a symbolic link but it works fine. The other option is to use the favorites feature above where the libraries are.
------------------------------------
Reply:
------------------------------------
Reply:
Come on MS!!!
------------------------------------
Reply:
Reference for enabling Windows Search Services:
http://technet.microsoft.com/en-us/library/ee461108(WS.10).aspx#BKMK_InstallWSandEnableFIleServices
SnoBoy
------------------------------------
Reply:
in order to index a network location within a corporate network it looks like the choices are to A) make the folder available off line so as to include it in a library - which works - until your TB network drive fills up your GB local HDD - or B) enable indexing on the server, which our network admins wont do because of all the legacy cr@p we have on our network. This is just S-T-U-P-I-D M$!! I was able to build a perfectly awsome and great local index which included the network locations of my choice, including email, using windows desktop search on my windows XP machine and it is ALL BROKEN now. You want us to adopt 7 in our corp environment but now I cannot search multiple network locations for information that I need to find that is part of my job here. That is too bad. I LOVE win 7 at home it is awsome, at work IT IS A PAIN IN THE ____!!!!
Please make the desktop search able to include specified network locations in a local index of files!!!!!!!!!!!!
------------------------------------
Reply:
== This is how to search network files and index network files without having to store a copy on your own dam computer. ==
So after a long hard search i have found the answer to my own problem. (putting up with this for 3 months)
This patch allows you to add network files to the index without having to make them "always available offline".
It will add a tab in the Indexing Options menu called "Add UNC Location" this is where you add the path of the network folder.
UNCFATPHInstaller.msi
To Add to Library
http://zornsoftware.talsit.info/?p=3
always available offline is not a real solution for network storage, you can't make 2TB available offline if you have a 200GB hard drive
------------------------------------
Reply:
------------------------------------
Reply:
A very interesting, effective, and well explained workaround for this issue. Go to this link.
http://www.winstructor.com/news/22/Windows-7-Training-%252d-Using-Windows-7-Libraries-with-Network-Drives-%28Free-Video%29.html
------------------------------------
Reply:
I wanted to install the mentioned HotFix on Win 7 Pro x64, but it wouldn't allow me (said it didn't apply to my system during installation). Tried the registry entries anyway and rebooted, but still won't let me select a network folder (on a NAS drive) for my libraries -- still gives the message it must be indexed.
I read the response about using Media Center, but instead I tried going into Windows Media Player and it DOES let me select the same NAS folder for each of the Libraries: Music, Pictures, Videos. After setting them up in WMP, now in Explorer the Library links for each of these areas resolves properly to the selected NAS folders!
If I can enter them in WMP and it ultimately updates the same library links in Explorer, why not just let me enter them in Explorer?
Hope this workaround helps someone.
------------------------------------
Reply:
now I am having issues in metro video app. Go figure.
- Edited by stevenlharris Friday, July 27, 2012 9:24 PM
------------------------------------
Reply:
I just wanted to add...my problem was that i couldnt index files on a Win2008R2 server from my Win7 machine, i fixed it by installing windows search role feature on the server, adding the drive with the media on it to the index on the server, and then CREATING A NEW SHARE FOR THE DRIVE
i was trying all the solutions while still using the d$ (Administrative) share, but networking does not seem to support remote indexing on administrative shares...
after creating a new share for the entire drive, and then mapping it from my win7 client, everything worked perfectly, i could add the music folder from the servers D: drive to my library
hope someone else was having exactly that problem :)
greetings
------------------------------------
Reply:
Hi!
Could you please anybody share the UNCFATPHInstaller.msi package? The MS link is not exist anymore, and I have to get indexed an UNC library on Windows 7 32bit system...
Any help is kindly appreciated...
Regards, Attila
------------------------------------
Reply:
------------------------------------
Filtering Data For Domain Based Attribute
Hi, Is it possible filter data showing in drop down for domain based attribute.
I have one entity which holds all the hierarchy data related to department, job position, and location.
What I want, when I am selecting data for department, dropdown should have records/names of departments only.
For now I am getting all the records and very tuff to select from the huge list.
Any help please.
Thanks,
Venkat
- Changed type Ed Price - MSFTMicrosoft employee Tuesday, January 20, 2015 5:07 AM
Reply:
Hi Venkat,
I suppose you are looking for this filter action in Excel?
I think you should able to ahieve this action in the latest MDS coming with SQL Server 2016.
So under Master Data ribbon,there is Filter button, clicking the button you should be able to set your own filtering rules.
After filtering, resulting list should be shorten, then you can use Save Query button to keep the filtering for your next time usage.
I wish I can post screen captures here but seems my account isn't yet verified by the forum.
Hope information above is enough for you?
Best regards,
Adam Zheng
------------------------------------
Filtered domain-based attributes
Hi
I have created the following entities, Product, Product SubCategory and Product Category
The Product SubCategory entity has an attribute called Product Category which is domain-based on the Product category entity.
The product entity contains the name, code attributes and product sub category and product category. Product Category and Sub Category are domain based attributes.
When a user creates a new product they will then select the product category value. Is it then possible to only show the related product sub categories for the select product category value? i.e. filtered domain-based values
Currently it shows all sub categories for all product categories.
I have been able to create a business rule that populates the Product Category from the Sub Category selected - traversing up the hierarchy, This works as there is only one parent. There is a requirement where they would like to traverse down the hierarchy when defining the product details in a filtered drop down approach. - 1 to Many
Any advice would be greatly appreciated.
Cheers
Kevin
- Changed type Ed Price - MSFTMicrosoft employee Monday, January 26, 2015 9:06 PM
Reply:
Hi Kevin,
I think what you looking to achieve is now available in the latest MDS.
Basically you need to create Domain-Based Attributes on product, one for Product Category, the other for Product SubCategory, then create Derived Hierarchy based on Product.
So then you go back to Product and config the Domain-Based Attribute for SubCategory to filter the derived hierarchy.
Below is a video from free edX MDS course by Peter Meyers, hope it helps
https://d2f1egay8yehza.cloudfront.net/MSXCMDSM2017-V002000_DTH.mp4
Best Regards,
Adam Zheng
------------------------------------
Deadlock graph
Hi
i have enabled extended events for Deadlocks, but when i see the graph it has too much of information and i cannot maximise the XML graph it, please let me how i can maximize each field and see whats happening.
thanks
Ranjith
- Changed type RANJITH K Wednesday, June 21, 2017 9:15 PM discussion
Reply:
------------------------------------
Reply:
------------------------------------
Feature Request - Get-SCOMAgent -Criteria
I'd like to add a feature request, although I'm not sure if this is the right forum. I'd like to see the Get-SCOMAgent PS cmdlet have the -Criteria parameter added to it, and on top of that, I'd like to see the FailoverManagementServers exposed in the base set of returned data rather than the extended data using
GetFailoverManagementServers().DisplayName
Here's why.
In our main management group, we have multiple Management Servers. There are servers dedicated to Unix/Linux monitoring, Network Monitoring, and APM. There is a pair of Management Servers which monitor all Windows agents, with a roughly 50/50 split of agent homing between them, and the capacity to absorb all the traffic from the other MS if it should go down. So, we set these two Management Servers to be failovers for each other.
However, by default, SCOM sets all Management Servers to failover to all the other Management Servers in the Management Group inside the trusted domain. We don't want them to randomly fail over to those, which are all multiple Management Servers in Resource Pools dedicated to whatever their function might be (Linux, Network, APM...).
For untrusted domains, the problem is slightly different. By default, SCOM does not assign a failover Management Server to *any* servers on the other side of a Gateway. For redundancy, we have two Gateway Servers in each untrusted domain.
In both cases, manipulation of the failover servers must be done using Powershell, and we do that by scanning each management server which monitors Windows Agents and iterating through all of the homed agents, and updating those which are incorrect (of course, if Windows Agents could be homed to Resource Pools like everything else, we wouldn't have this issue).
This requires the following syntax:
Get-SCOMAgent-ManagementServer$primaryms|WHERE{($_.GetFailoverManagementServers().DisplayName) -ne"$newfailover"}
You see the problem.
First, because we are piping the output of Get-SCOMAgent to a filter, Get-SCOMAgent is actually returning all of the records for a particular Management Server, but filtering them after the pipeline, so the results that are actually returned are what we want, but the query is inefficient, and takes a very long time to execute.
Second, because the list of failover management servers are not returned in the base set of values, we have to use the extended data reference, which (I *think*) would not work even if -Criteria were available with Get-SCOMAgent because we couldn't just say Get-SCOMAgent - ManagementServer $primaryms -Criteria "FailoverManagementServers -ne $newfailover"
Make sense?
- Changed type HS Brown Wednesday, June 21, 2017 9:24 PM Feature Request
MS Excel Power Query not refresh if file is not open when choosing Refresh every x minutes
I'm using MS Excel 2013 with Power Query add-in.
I have a table with data source from Oracle. Everything is ok - I can manually refresh the data, etc.
Then I want to setup auto refresh by the following:
in the "Connection Properties", in Usage tab, under Refresh control, I choose "Refresh every 5 minutes".
I saved the file and close the excel file.
After 5 minutes, I opened the file and found the data was NOT refreshed.
However, if I open the file and keep it open for 5 minutes, I can see the data is automatically refreshed.
Anyone knows why the closed file cannot get refreshed as configured or this is the requirement by MS Excel to keep the file open for refreshing data in regular basis (every x minutes)?
Any suggestion? What I want is to avoid human intervention and have file refreshed when it is closed (I know there is an option to refresh data when opening the file).
Bring back Hyper-V to Nano Server!
Why are you killing Hyper-V (and all other Infrastructure Roles) on Nano Server???
Nano Server only for Containers is a very bad decission from my Point of View!
- Changed type Michael-CM Thursday, June 15, 2017 5:10 PM
- Edited by Michael-CM Thursday, June 15, 2017 5:19 PM
Reply:
You do realize that Server on Bare Metal = Core.
And Core will begin light with only adding roles. Similar theory to the original Nano concept.
Nano is moving to the Container layering approach. An evolution that makes a bit of sense.
Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.
------------------------------------
Reply:
Yes if Core would be small and fast as possible because i only add the roles i need and nothing more (like in Nano Server) i would agree.
But at the moment Windows Server Core has too much footprint on disk comparing to Nano Server. It should be also completely headless like Nano.
- Edited by Michael-CM Thursday, June 15, 2017 6:28 PM
------------------------------------
Reply:
You do realize that Server on Bare Metal = Core.
And Core will begin light with only adding roles. Similar theory to the original Nano concept.
Nano is moving to the Container layering approach. An evolution that makes a bit of sense.
Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.
Nano on metal = core? I am confused by that. I have a test system running Nano Hyper-V on metal and although I added the core drivers it is still a Nano server as far as I can see. Can you elaborate on that please?
------------------------------------
Reply:
Nano on bare metal WILL be no more.
it is being optimized for Containers exclusively.
On bare metal you will need to use Server (core).
This is the direction Server is headed in.
This was revealed at //BUILD in a couple sessions and recently on a blog.
Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.
------------------------------------
Reply:
------------------------------------
Reply:
It's a big step backwards for the infrastructure roles (Hyper-V, Cluster, File Services). Server Core is again a Platform which has to much components i never need + slower boot times + more updates + not headless. That's not "continuous Innovation" for me.
- Edited by Michael-CM Friday, June 16, 2017 10:18 AM
------------------------------------
Reply:
Please remember to mark my post as an answer, if I really helped you out, or vote if usefull. Thank you!
------------------------------------
Windows 10 Autounattend.xml TypeID issue.
I'm having issues with my autounattend.xml, it errors out on <DiskConfiguration>
This xml if for BIOS not UEFI, so I have two partitions that Pass 1 creates, System and OS.
During test deployments WinPE is complaining about TypeID for Partition 1 which is the 250MB system partition.
When I look at MS documentation the only TypeId for BIOS that exists is for OEM and recovery partitions.
Here is my <DiskConfiguration> 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>250</Size> <Type>Primary</Type> <Extend>false</Extend> </CreatePartition> <CreatePartition wcm:action="add"> <Order>2</Order> <Type>Primary</Type> <Extend>true</Extend> </CreatePartition> </CreatePartitions> <ModifyPartitions> <ModifyPartition wcm:action="add"> <Format>NTFS</Format> <Label>System</Label> <Order>1</Order> <PartitionID>1</PartitionID> <Active>true</Active> <TypeID></TypeID> </ModifyPartition> <ModifyPartition wcm:action="add"> <Order>2</Order> <Letter>C</Letter> <Label>PJLM-PC</Label> <TypeID></TypeID> <Format>NTFS</Format> <PartitionID>2</PartitionID> </ModifyPartition> </ModifyPartitions> <DiskID>0</DiskID> <WillWipeDisk>true</WillWipeDisk> </Disk> <WillShowUI>OnError</WillShowUI> <DisableEncryptedDiskProvisioning>false</DisableEncryptedDiskProvisioning> </DiskConfiguration>
Any ideas?
Reply:
Ha, as soon as I posted the above question I managed to fix it.
I used Notepad ++ to open the Autounattend.xml and manually removed the <TypeID></TypeID> tags from the <ModifyPartition> section.
Hopefully it'll help out others.
EDIT: Also noticed I posted this in the Win7 section, could a moderator move it to Windows 10 section?- Edited by La Chupacabra Wednesday, June 21, 2017 4:13 PM
------------------------------------
how to create a windows login who is not in a domian
Hi experts i am looking for a suggestion on how to create a Windows login and then grant access to SQL Server who is not in our XYZ domain, he is a consultant, and we are obligated to create sql logins.
Thanks,
Reply:
Connect to the SQL Server machine - ie using RDP.
Create a local user account using Computer Management.
If the machine name is SQLServerDEV you would add his login as
SQLServerDEV\HisName
ie
CREATE LOGIN [SQLServerDEV\HisName] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
As long as his password he uses to logon to his desktop/laptop, matches the password you enter on the SQL Server machine, he should be able to logon.
- Edited by Hilary CotterMVP Wednesday, June 21, 2017 2:53 PM
------------------------------------
Setting up map drives for Oracle UCM folders without getting disconnected
All,
We are trying to set mapping drive for folders within Oracle UCM and we are successful in setting it but after log out when we log back in again, we are losing the connection. So is there a work around in order to keep mapping drives losing the connection during and after log out???
Please reply back for the question
Thanks,
Rahul Vaghela
Reply:
Hi Rahul,
Do you know the how to map the UCM folders (fin/expense/inbound or outbound)?
Our use case is like below
We are integrating on premise EBS 11I with Expense Cloud using SOA cloud service.
There are two integrations. First creates AP invoices in EBS from Expense Reports generated on cloud and second updates the payment info from EBS invoice payments onto the cloud.
Both integrations use xml files. In the implementation manual it is mentioned that the XML files are generated under the UCM folder under fin/expenses/outbound folder upon running a process in Expense cloud.
In our SOA composite we are using a file adapter to poll a physical folder for xml files. We want to poll this folder where the XML files are generated.
Question is how to provide the absolute path of the UCM folder in SOA cloud so that the generated xml files can be processed?
Can you please confirm that this the correct method of processing expense reports and integrating with on premise EBS.
Thanks,
Shubhashish Durge
------------------------------------
Facing Problem Logging Into Roadrunner Email Account
how to use a free yahoo mail account with outlook with i map
Reply:
I HAVE NEW APPLICATION WITH YAHOO MAIL ACCOUNT AND OUTLOOK.
Not sure what you mean by "have new application" but the info for Yahoo IMAP settings is contained in the following
IMAP server settings
https://help.yahoo.com/kb/imap-server-settings-sln4075.html
Karl Timmermans [Outlook MVP] "Outlook Contact Import/Export/Data Mgmt" http://www.contactgenie.com
------------------------------------
Reply:
------------------------------------
Microsoft Project has stopped working
Hi,
I face an issue while opening a Project in MS Project 2013 from PS 2013.
How do I resolve it? Or how can I get a copy of this Project Plan so that I can publish ass a new project?
It shows an error (screenshot below):
Thanks,
Noman Sohail
Reply:
Hello,
Can you open the project to edit in the browser using PWA? Make a minor change such as adding a new task then save and publish it via PWA. Once completed, check in the project then try again via Project Pro.
Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
------------------------------------
Reply:
Hi Paul,
I have already done this, edit the project in PWA and added a new task then Save & Publish, in this case it gives an error:
Regards,
Noman Sohail
- Edited by NomanSohail Monday, March 27, 2017 7:53 AM Update
------------------------------------
Reply:
Does it give his error on the save or the publish or both? Anything in the ULS logs? Does the job enter the queue?
Paul
Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads
------------------------------------
Reply:
It give the same error on both Save & Publish via PWA.
Interesting thing is no entry in ULS logs and even no queue job for this.
But it stucks in queue while Check-in the project.
Can I export/copy .mpp from database or anywhere, so that I can make changes and use this project plan?
Regards,
Noman Sohail
- Edited by NomanSohail Monday, March 27, 2017 8:28 AM Update
------------------------------------
Reply:
We use Project Server 2013 and Project Professional 2013.
We have the identical problem with one of our project files. The only difference is that we are able to save and publish the project in PWA.
------------------------------------
Reply:
Did you try to open the project both from DRAFT and PUBLISHED database?
Thanks
Sakthi.
------------------------------------
msExchMailboxGuid attribute is set to Null for remote mailbox
Hello Experts,
We are in process of on boarding to Microsoft Office 365 Exchange Online, while creating the remote mailbox the object on premise is not stamped with msExchMailboxGuid and the attribute value is set to "00000......". This is causing issue with off boarding the mailboxes from Exchange Online.
It appears to be by design.
Now the question is, is there a way to synchronize the value of msExchMailboxGuid attribute back to on premise remote mailbox object. If yes; is it considered a supported scenario and how to achieve this?
Thanks in advance.
Mubashir Mir
Reply:
Hello Mubashir,
Ideally msExchaMailboxGuid attribute cannot be written back to on premise environment using Azure AD connect. Please find the list of attributes that can be written back to on premise in exchange hybrid scenario.
https://docs.microsoft.com/en-us/azure/active-directory/connect/active-directory-aadconnectsync-attributes-synchronized
Thanks,
Vishagan
------------------------------------
Reply:
Hello Mubashir,
Was the reply helpful?
Any queries regards the issue?
Regards,
Vishagan.
------------------------------------
Reply:
Hello Experts,
We are in process of on boarding to Microsoft Office 365 Exchange Online, while creating the remote mailbox the object on premise is not stamped with msExchMailboxGuid and the attribute value is set to "00000......". This is causing issue with off boarding the mailboxes from Exchange Online.
It appears to be by design.
Now the question is, is there a way to synchronize the value of msExchMailboxGuid attribute back to on premise remote mailbox object. If yes; is it considered a supported scenario and how to achieve this?
Thanks in advance.
Mubashir Mir
When you enable the remote mailbox on-prem, add the Exchange guid to the object as part of your provisioning process:
Set-RemoteMailbox user -ExchangeGuid <GUID>
This will allow you to move the mailbox back on-prem if ever required.
------------------------------------
Reply:
Hey Mubashir,
Did you end up solving this? We are dealing with the same issue requiring us to manually match the ExchangeGuid- we are trying to automate this process so this is causing some pain.
The previous responses added some light to our issue but are not sufficient to solve it.
------------------------------------
Physical joins in SQL
Hello,
I want to discuss about the physical joins selection by the query optimizer, that on what basis the optimizer chooses the physical joins, i.e. it might be a merge/ nested loop / hash match join.
I am totally confused while working on them.
Reply:
This is a pretty good description of the difference between the 3.
https://tomyrhymond.wordpress.com/2011/10/01/nested-loop-hash-and-merge-joins/
A merge join is chosen when both of the join columns are sorted.
A hash join is used when the # of inputs on one side far outweighs the number on the other. A hash is built on the smaller number of inputs and then compared against the large number of inputs.
In a nested join the outer loop consumes the outer input table row by row. The inner loop, executed for each outer row, searches for matching rows in the inner input table.
------------------------------------
Reply:
The SQL Server optimizer is cost-based so the selection of physical join operators is based on the estimated number of rows that might be returned and the estimated costs associated with the different types of joins.
You'll need to be more specific with your question if you need a more precise information.
Dan Guzman, Data Platform MVP, http://www.dbdelta.com
- Edited by Dan GuzmanMVP Wednesday, June 21, 2017 1:16 AM
------------------------------------
Reply:
Hi mkanurag,
In your scenario, you can refer to this article: Advanced Query Tuning Concepts
If one join input is small (fewer than 10 rows) and the other join input is fairly large and indexed on its join columns, an index nested loops join is the fastest join operation because they require the least I/O and the fewest comparisons.
If the two join inputs are not small but are sorted on their join column (for example, if they were obtained by scanning sorted indexes), a merge join is the fastest join operation. If both join inputs are large and the two inputs are of similar sizes, a merge join with prior sorting and a hash join offer similar performance. However, hash join operations are often much faster if the two input sizes differ significantly from each other.
Hash joins can efficiently process large, unsorted, nonindexed inputs.
Also, you can refer to these articles:
Understanding SQL Server Physical Joins
LOOP, HASH and MERGE Join Types
Thanks,
Xi Jin.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
------------------------------------
How to Integrate SSRS Reports in Application without using IFrame
ch.kishore
Reply:
Olaf Helper
[ Blog] [ Xing] [ MVP]------------------------------------
Delete computer from AD, join to AD then move to new OU script
I use WDS with MDT (not SCCM).
Currently, when re-imaging a computer have to manually delete the computer from AD so that when the joindomain TS runs, the computer is added to my "staging" OU. This OU was created so that the company agreement window does not break the autologin sequence when MDT is imaging a computer. Once the image is complete, I move the device to the proper OU that the Task sequence is built for. Example, I have a TS that's designed to install all the software that our Support team uses so when the TS is finished I would move the computer to the Support OU.
What I am looking for:
A vbs or PS script that first scans AD (I have two 2012r2 AD servers in failover move if that matters) for the PC name that it was given during the MDT wizard before the device is attempted to join the domain. Once the device is found, it is deleted from AD. Then the device is joined to the domain and sent to the "staging" OU (currently the custom.ini joins the device to the proper OU only if the device is not in AD. If it is, then it does not move the device to the staging OU. It stays in whatever OU it was in prior to the re-image, this breaks the TS which I explained above). Once the rest of the TS is finished I would like one more script to move the device from the staging OU to a new OU. Since the script will be running locally on the PC, the script must be able to identify what the computer name is and ONLY move that computer to the new
If you could help me with this, that would be greatly appreciated.
Thanks!
- Changed type Bill_Stewart Wednesday, July 26, 2017 7:40 PM
Reply:
What I am looking for:
Unfortunately you are looking in the wrong place, because this isn't a script request forum.
Please read this first (it's right at the top of this forum):
This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
I appreciate the reply back and I have already read what you have provided, but as you can see my first and only question was to see if a script(s) existed. I was not asking anyone to write a script for me. I went into detail of what I am looking for so I do not get simple "Move to new OU script" links as I have read millions of those threads already.
If someone can point me to a script that already exists, that would be fantastic. :)
------------------------------------
Reply:
The odds of finding a script that already does exactly what you want is probably pretty small, but of course you're free to search. The gallery probably contains scripts that do similar kinds of things to what you want, and you can use those as examples.
As far as pointing you to a specific script, unfortunately we don't have the time to research this for you. You will need to do the searching on your own. (Keep in mind that we're volunteers - this forum is peer-to-peer with no SLA.)
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Again, thank you. I understand what this forum is for and how it works. I came here because what I am looking for does not seem to be that odd of a script since many people use MDT and SCCM. Joining domains, moving OU's and such are very common. Unfortunately, I am no scriptor (scripter? either way I don't write scripts or programs) so I cannot accomplish this on my own. I do not need people researching this for me, I have spent a few days looking for something similar. I figured I might get lucky and someone who is in the Desktop Administration role and works with MDT/SCCM would see this and know exactly what I am speaking of.
Thanks again, Bill.
------------------------------------
Reply:
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Moderator or not, please remove yourself from my post. At this point you are just flooding it with non-sense.
Removing your unhelpful and uninformative comments would be much appreciated too.
- Edited by TheUsD Tuesday, June 20, 2017 6:57 PM
------------------------------------
Reply:
I agree with Bil. You question is more tailored to needing a consultant to sort out what you are trying to do.
Mostly, MDT can do all of this without a script so you should start in the MDT forum to learn how to use MDT to perform most of your requirements.
Unfortunately forums are not a good place to ask for extensive and complex solutions. Scripting forums are designed to answer specific questions about scripting and no as a place to find free scripts or have people design scripts for you. If you can't find a script by search then pick one that is close and modify it. You can then post back with specific issues you may be having.
\_(ツ)_/
------------------------------------
Reply:
If MDT could do this, I would have not posted this question. MDT can only join a device to a domain. Once you have chosen the domain, it is up to a vbs or PS script to tailor the rest. Again, this is not a very unique question to ask.
If you are to ask someone in the field who uses MDT / SCCM they will direct you to scripting. Either way, I'm asking a question for exposure. There is absolutely no reason to mark a question answered without there being an answer. Marking it answered would not only prolong the possibly of someone who knows of a script or has a script posting a link to my question, but could also make someone who has the same question click this thread and read all of the unhelpful comments.
I am not needing a consultant as I am the person who manages all the imaging. I can manage the task manually but am looking to make a few things more automated for myself so I can concentrate on other tasks and be more proficient.
- Edited by TheUsD Tuesday, June 20, 2017 8:47 PM
------------------------------------
Reply:
So what you are trying to do has nothing to do with an MDT. If that is the case then, if you ask a basic scripting question, you will likely find it easier to find an answer.
If you are looking for how to move an object in AD then ask that question. "How do I move an object to a new OU?"
Which by the way can be included in an MDT XML spec. It can join into a default OU or specific OU and "post-imaging" move to a new OU.
To move with PowerSHell read the following:
help Move-AdObject -Full
\_(ツ)_/
------------------------------------
Reply:
It sounds to me like you think you need to move the computer object after creating it.
I would recommend creating the computer in the OU that you want to begin with. Then there's no need to move it afterward. PowerShell:
PS C:\> New-ADComputer COMPUTER1 -Path "OU=My OU,DC=fabrikam,DC=com"
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
The issue with:
PS C:\> New-ADComputer COMPUTER1 -Path "OU=My OU,DC=fabrikam,DC=com"
Is that you would still have to (from my understanding) manually edit the
script to the computer I am imaging which is still a manual process, lol.
- Edited by TheUsD Tuesday, June 20, 2017 9:27 PM
------------------------------------
Reply:
Do you have a specific scripting question you'd like to ask?
If not, then we need to close this topic, because as noted, this is not a consulting forum.
(By consulting: I mean that you specify your requirements and someone confers with you and writes code for you that meets those requirements. That's not the purpose of this forum.)
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Here is an example of how to join to a staging OU then move to a target OU using deployment technologies. There are other approaches that can also be used.
http://maikkoster.com/moving-computers-in-active-directory-during-mdt-deployments-step-by-step/
I recommend going over the documentation for the current version of MDT. All of this can also be done with SCCM with basic "Task Sequences".
Post in the MDT forum for help with getting your outcome. Most experienced users of MDT can show you where to look in MDT to tweak your deployments.
As Bill has noted, you are not asking a scripting question. You are fighting with how to use MDT to do a simple MDT task.
Here is a link to the MDT forum: Microsoft Deployment Toolkit
\_(ツ)_/
- Edited by jrv Tuesday, June 20, 2017 10:04 PM
------------------------------------
Reply:
Here is another article showing how to define "Post OS" tasks. https://scriptimus.wordpress.com/2012/09/13/ltizti-deployments-post-os-task-sequence/
It is recommended that all security group additions and OU moves be added as a Custom Task".
To do this on workstations and computers without RSAT installed you would use basic ADSI. See Gallery for many examples of ADSI scripts that can perform all of these tasks. Arguments to these scripts are provided for the Task Sequence variables as defined by your deployment type.
I did a quick search and found at least 10 methods moving a computer account to a new OU with MDT. This is but one method. Under SCCM there are other, more useful, methods for doing this.
By posting in the MDT forum you will find other users of MDT will have other methods that will help you resolve your issue.
Again - this is not really a scripting issue. It is a deployment issue and requires that you have a good understanding of MDT and deployment technologies.
\_(ツ)_/
------------------------------------
Reply:
I did a quick search and found at least 10 methods moving a computer account to a new OU with MDT.
Again - this is not really a scripting issue. It is a deployment issue and requires that you have a good understanding of MDT and deployment technologies.
\_(ツ)_/
As much as I appreciate the condensing tone as the next person, I've read this along with countless other articles.
This is a scripting issue.
Bill,
A few replies prior you asked if I had any specific scripting questions. Yes I do. See if you can help answer this one, if you can't no need for replying.
Thanks!
Is there a PS script that I can use or a guide I can be shown that shows me how to do the following:
I use WDS with MDT (not SCCM).
Currently, when re-imaging a computer have to manually delete the computer from AD so that when the joindomain TS runs, the computer is added to my "staging" OU. This OU was created so that the company agreement window does not break the autologin sequence when MDT is imaging a computer. Once the image is complete, I move the device to the proper OU that the Task sequence is built for. Example, I have a TS that's designed to install all the software that our Support team uses so when the TS is finished I would move the computer to the Support OU.
What I am looking for:
A vbs or PS script that first scans AD (I have two 2012r2 AD servers in failover move if that matters) for the PC name that it was given during the MDT wizard before the device is attempted to join the domain. Once the device is found, it is deleted from AD. Then the device is joined to the domain and sent to the "staging" OU (currently the custom.ini joins the device to the proper OU only if the device is not in AD. If it is, then it does not move the device to the staging OU. It stays in whatever OU it was in prior to the re-image, this breaks the TS which I explained above). Once the rest of the TS is finished I would like one more script to move the device from the staging OU to a new OU. Since the script will be running locally on the PC, the script must be able to identify what the computer name is and ONLY move that computer to the new
If you could help me with this, that would be greatly appreciated.
Thanks!
------------------------------------
Reply:
It is very hard to understand your question as it always begins with a reference to MDT. This is not an MDT forum.
You are not asking a scripting question. You are asking for a number of scripts to do various tasks. How about asking a single scripting question with no reference to MDT.
What is you first script issue?
\_(ツ)_/
------------------------------------
No comments:
Post a Comment