Friday, 14 January 2022

Sharepoint Calulated Column Question

Sharepoint Calulated Column Question

How do you make Calculated Column in SharePoint  displays information from other columns in a column format. Here is what I am able to do.

=concatenate([task description 1],"-",[task description 2])

Example: This is only a test-This is only a test

How do I get the formula to show it like the following?

Example: This is only a test

               This is only a test

Please help!!!!

HTML to XHTML Transitional Issue

This was improved from the old <br /> to <br> </br>.

But before, it was still in a lot of HTML Web pages. Then it gradually faded out towards XHTML.

I'm not sure this transition was as smooth as it should of been. It was disappointing, Web sites kept using outdated HTML in the past.

Sysmon v11 not logging ProcessCreate events for Win10 versions 1507 thru 1607

Hi all,

Anybody else seeing this?  With the below configuration in place (and many other similar variations), when I open and close an app, I get the ProcessTerminate events (ID 5) but never the ProcessCreate events (ID 1).  All other OSs seem fine (Win7/WS2008 through Win10-v2004).  These are all VMs; I have not yet been able to test a physical machine with one of the problem OSs.

EDIT: Dropping back to Sysmon v10.42 brings back ProcessCreate events.


Dave


  • Edited by Dave Schob Wednesday, June 17, 2020 7:10 PM

Reply:

I have confirmed this also occurs on physical machines.  I've check v1507 and v1607; both fail to log ProcessCreate events using even this simple config:

<Sysmon schemaversion="4.22">   <!-- Capture MD5 and SHA1 hashes -->   <HashAlgorithms>MD5,SHA1</HashAlgorithms>   <EventFiltering>   <!-- Events to include -->   <ProcessCreate onmatch="exclude" />   <ProcessTerminate onmatch="exclude" />   </EventFiltering>  </Sysmon>


Dave


------------------------------------
Reply:

Hi Dave

this is a known regression for Sysmon 11 on some older SKUs. We have resolved the issue for Sysmon 11.10 which was supposed to be published yesterday. I am going to chase Mark R. on this today but in the meantime if you would like a pre-release version ahead of the publication please ping me at syssite@microsoft.com and I can make it available to you.

MarkC(MSFT)


------------------------------------
Reply:
Thanks a bunch for the confirmation, Mark.  I've reverted to v10.42 on those problem VMs and will wait for the official 11.10 release.  I'll reply here when I've tested it.

Dave


------------------------------------

"No authentication failed" when login through oAuth2 to outlook using imap protocol

"No authentication failed" when login through oAuth2 to outlook using imap protocol.

I am trying to authenticate outlook account using chilkat Imap.connect().

When using access token to login(), I am getting authentication failed error.


Reply:

Yes....I also facing to this problem.

I retrieved access token by grant_type=client_credentials because I am using this in service application.

But when try to login chilkat Imap.Login() by office 365 account name and access token it gives the "No authentication failed" error.

Highly appreciate quick response.


------------------------------------

Discover 20H1 from A to Z

Curious about what all is packed into 20H1? This gives a good & comprehensive breakdown and you the complete lowdown. Some is for IT Pros & Biz Users, but still interesting & informative for ALL End Users. There's lots of good stuff this Update.

Clickable ����
Image

Cheers,
Drew
Image

Drew - IT Pro / MS Partner/Partner Company / Windows Insider / Owner - Computer Issues

Hyper-V easy manager tool to manage VM

Hi community, 

after your authorization,

i m very happy to present my contribution to you, it is a free tool created by myself, to help everyone use Hyper-V on local or remote server, and encourage the people to use Hyper-V.

all your feedback is welcome,

this is the link :

https://github.com/dakhama-mehdi/Hyper-VEM

if anyone has any  suggestions or improvement, please feel free to give me the advice




  • Edited by M dakhama Thursday, June 18, 2020 1:17 AM

Reply:
Great job , Keep it Up 

------------------------------------
Reply:
Great job 

------------------------------------
Reply:
Looks good.

------------------------------------
Reply:

I present you, a new version for my free tool to manage Hyper-V, it is very stable and very fast.

thanks,


------------------------------------
Reply:
Looks Pretty good! :D

------------------------------------
Reply:
Thanks

Miguel Fra
Falcon IT Services
https://www.falconitservices.com

 


------------------------------------

How to DUAL BOOT Corporate windows 7 (bitlocker and TPM 1.2) and Windos 10 (preferably with bitlocker)

Hi, 

I need some assistance with dual booting my laptop with windows 7 pro and windows 10 pro. I currently have one hard drive with 3 NTFS partitions (System, Windows 7 with bitlocker, and an empty partition) My laptop has a TPM 1.2 chip and has bitlocker enabled on the currently installed windows 7 partition. I would like to install windows 10 on the 3rd empty partition (would prefer to use bitlocker on this partition but it is not a requirement). My initial logic was to just run the windows 10 install and select the empty partition for the install. After I would turn on bitlocker in Win10 if possible.

Would my method work for installing Win10 on the 3rd partition or are there extra steps needed because of the TPM and currently encrypted Win7 partion?

If not what are the extra steps or can it even be accomplished?

Best Regards,

Rudy


Reply:

Hi Rudy

did you ever manage to get this working, I am ready to try the same thing with 2 win 10 and 1 tpm chip on a desktop and a laptop

Regards,

Rob


Rob


------------------------------------
Reply:

Hi, Rudy, Rob,

I have Windows 10 Enterprise (work OS) and Windows 10 Pro (personal OS) installed on two pertitions, and a common "Data" Partition as third one.

My Lenovo Carbon X1 has TPM2.0 enabled.

Turned on BitLocker on Work OS succesfully

When I logged on my Personal OS and turned on BitLocker (previously saved recovery key), after reboot, when I choose Personal OS, it asks me for Recovery key. When I type IT I get disk error and BSOD.

I can still login to Work OS, and when I tried to access Personal OS partition from it, it asks me for a recovery key and when I type it (it is correct and it matches identifier) it says that key "doesn't match the drive".

M3 BitLocker Recovery tool doesn't help either.

I don't know if this is a valid scenario but it is not working!!!

What i wanted to achieve is to have same hardware for different purposes (private and business), and to separate them with bitlocker (so I cannot access work drive from personal OS and vice versa).

Any ideas?


------------------------------------
Reply:

Hi Milpav,

I had the exact same scenario on my Razer laptop. Never found a resolution. Just checking to see if you ever found anything on this?



------------------------------------
Reply:
Any answer? Would like to do this with W7 and W10 with BitLocker for both. Years ago I was able to do with with Vista and W7 and even added an enhanced PIN. The instructions were on TechNet. Am hoping its much simpler as I can't recall how to accomplish this now.

------------------------------------

How to convert Nested data into json data using Powershell

Hi,

I am trying to convert below formatted data into json data using below power command but i am not able to see nested json data properly converted and it showing empty.

Example: store nested data is available in object data but when we converted to json it is showing empty. Can you please help how to display store data as well. 

$json = @'  {"value":[{"id":"/subscriptions/xxxxxxxxx/resourceGroups/xxxxxx/providers/Microsoft.DataFactory/factories/xxxx/linkedservices/xxxx  xxx","name":"xxxxxx","type":"Microsoft.DataFactory/factories/linkedservices","properties":{"annotations":[],"type":"AzureKeyVault","typeProperties":{"baseUrl":"https://ak  xxxxxx.vault.azure.net/"}},"etag":"xxxxx"},{"id":"/subscriptions/xxxxx/resourceGroups/xxxxx/providers/  Microsoft.DataFactory/factories/xxxxx/linkedservices/xxxx","name":"xxxxx","type":"Microsoft.DataFactory/factories/linkedservices","properties":{"an  notations":[],"type":"AzureDataLakeStore","typeProperties":{"dataLakeStoreUri":"adl://xxxxx.azuredatalakestore.net/","servicePrincipalId":"xxxxxxx  ","servicePrincipalKey":{"type":"AzureKeyVaultSecret","store":{"referenceName":"xxxxx","type":"LinkedServiceReference"},"secretName":"data-client-secret"},"tenant  ":"xxxxx","subscriptionId":"xxxxx","resourceGroupName":"xxxxxx"}},"etag":"xxxxxx  "}]}  '@ | ConvertFrom-Json    $json.value | Where-Object{$_.properties.type -eq "AzureDataLakeStore"} | ConvertTo-Json

Output:

{
    "id":  "/subscriptions/xxxxx/resourceGroups/xxxxx/providers/\r\nMicrosoft.DataFactory/factories/xxxxx/linkedservices/xxxx",
    "name":  "xxxxx",
    "type":  "Microsoft.DataFactory/factories/linkedservices",
    "properties":  {
                       "an\r\nnotations":  [

                                           ],
                       "type":  "AzureDataLakeStore",
                       "typeProperties":  {
                                              "dataLakeStoreUri":  "adl://xxxxx.azuredatalakestore.net/",
                                              "servicePrincipalId":  "xxxxxxx\r\n",
                                              "servicePrincipalKey":  "@{type=AzureKeyVaultSecret; store=; secretName=data-client-secret}",
                                              "tenant\r\n":  "xxxxx",
                                              "subscriptionId":  "xxxxx",
                                              "resourceGroupName":  "xxxxxx"
                                          }
                   },
    "etag":  "xxxxxx\r\n"
}



Reply:

Add the parameter "-Depth 10" to the ConvertTo-Json cmdlet.

The value "10" is just an arbitrary choice in this case. It just exceeds the depth of the nested data.


--- Rich Matheisen MCSE&I, Exchange Ex-MVP (16 years)


------------------------------------
Reply:
thank you so much Rich. It is working and my issue is resolved :)

------------------------------------

SUCCESSOR RDCMAN - THE NEW TOOL RDC-ON (REMOTE DESKTOP CONNECTOR)

Hi community and Hi family,

i hop you are good, i want to present you the alternative of RDCMAN, the RDC-ON that i created when Microsoft removed RDCMAN for vulnerability, this tool is very secure, easy to use, and propose more functions that RDCMAN, of corse free.

i can add other features like (telnet or SSH) is that interessed the membre. 

Link to test.

Best Regards,

https://gallery.technet.microsoft.com/Hyper-Virtual-Easy-Manager-6384c1c6


  • Edited by M dakhama Wednesday, April 1, 2020 10:47 PM

Reply:

Hi everyone,

I new version is availed, enjoy


------------------------------------

Render image with text boxes on top to word

Hello,

I have a multi page SSRS report. On 1st page I want to show a image and some dynamic text on top. I have tried below two ways to do this but none of them worked for me. Please let me know if someone has resolved this issue. I am usin the image doesn't render, showing only white background rectangle.

2: Placed a image object and added image g SSRS 2016

1: Added a rectangle or text box, changed the background image and placed text boxes on top. It works fine in report builder preview. But when I export it to word,in to it. Placed text boxes on top. Everything works fine in report builder preview. But when I export to word, Image is showing perfectly but text boxes not showing on top of the image they misaligned and changed their position to bottom of the page.  

Please let me know if anyone has solution of this problem. 



No comments:

Post a Comment

Sharepoint Calulated Column Question

Sharepoint Calulated Column Question How do you make Calculated Column in SharePoint  displays information from other columns in a col...